Hi all !!

I have a table which contains names of the cities, many a cities having space in the 
names like Anand UA, I am using MB and I am fetching the names into a variable 
and using select command. what happens is SQL takes only first word and ignores
 the word after space, i.e it takes only Anand and take UA as second character which
generated error message as well I am unable to get the desired results. 
        I tried using like also but the same thing happens. Is there any way in MB 
where 
I can handle such conditions,  or can is it possible I fetch only selected characters 
in the 
name so that I can use like , or something like this.
        
Thanks in advance.
Aditya
Executive (Systems) 
Information Systems Department
GCMMF, Anand
[E-mail me at [EMAIL PROTECTED]]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

Reply via email to