I don't want Word with anything after, i just want Word with e or s,
only that. So i can't use the %.
Thks for your help.
"Oscar Santiesteban Jr." <os***************@worldnet.att.net> wrote in message news:<El*********************@bgtnsc04-news.ops.worldnet.att.net>...
Have you tried,
select * from Table where column like 'Word%'
This will select any record where the column starts with Word and anything
after that.
Oscar...
"Benoit Le Goff" <be***@caramail.com> wrote in message
news:b4*************************@posting.google.co m... Hi,
i want to search record in a table where a varchar column is equal to
a word or this word with the letter 's' or this word with the letter
'e'.
Today, i've this query :
select * From Table Where Column = 'Word' or Column like 'Word[es]'
I want to remove the 'or' of this query to have only one condition.
Does someone know a solution to my problem.
Excuse my poor english language.
I hope you understand my problem and thks for solution.