how to "select" from mapinfo number field by like? [Archive]

blackantt

2011-09-27, 08:28 PM

for example,the state will get error:type dismatch

select * from a where ci like "%561%" ,ci is a number field.

maahsan

2011-09-28, 05:58 AM

Remove quotes i.e., "" if the CI is integer or float.

blackantt

2011-10-23, 09:43 PM

i got it.

Format$(CI, "#") like "%31753"