query problem

[Anon]

hi everyone,

i have a field call state...data inside this field separate by comma...johor,kl,ipoh.i want to query out data from state field which content johor,ipoh dosen't matter if there is other state name.is it possible.can anyone help me.

thanks in advance

[Anon]

WE NEED TO REMOVE A HIDDEN CARRIAGE RETURN CHARACTER FROM THE END OF A TEXT STRING WHERE WE DO NOT ALWAYS KNOW THE EXACT LENGTH OF EACH TEXT STRING, THEREFORE WE CAN'T USE THE RIGHT SUBSTRING FUNCTION.

ANY IDEAS WOULD BE GREATLY APPRECIATED.

PATRICIA

[Anon]

did you ever use "LIKE" ?? for example..

select * from tablename where state LIKE "%johor%"

enjoy
Tabish

[Anon]

i try that before but it no use because i am not going to query out one state only as u said...if one state only its possible use LIKE %johor%.....but here i have check 2 or more state....is there any other way....

thanks in advance

[[deleted]]

ALL YOUR CAPSLOCK KEYS ARE BELONG TO US

hidden carriage returns?
You always know the exact length of a string, that's what the strlen() function is for....