I have a column named "address". worker's addresses is written in here. i want to search for address column but with "WHOLE WORD" technique.
for example, suppose that, there is the address:
"abc street, def road no:21"
when i use that command:
select * from Table1 where address LIKE 'ab'
it gives the above address, because of abc street.
but i don't want to get that result, because there is no "ab" in that address. in other words, i want to search a "whole word" in the address.
in other words, to get this result, the user must type "abc" not "ab".
what command should i use for that? i am a newbie in asp. if you can help me it will be gladly appreciated.
2007-09-09
08:24:15
·
2 answers
·
asked by
destinys child
3
in
Programming & Design