469,106 Members | 2,327 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

Using like predicate

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.
Jul 20 '05 #1
2 2573
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.

Jul 20 '05 #2
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.

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by bdinmstig | last post: by
10 posts views Thread by William Krick | last post: by
2 posts views Thread by Srini | last post: by
reply views Thread by adebaene | last post: by
2 posts views Thread by =?iso-8859-1?q?Jean-Fran=E7ois_Michaud?= | last post: by
5 posts views Thread by =?Utf-8?B?U2llZ2ZyaWVkIEhlaW50emU=?= | last post: by
8 posts views Thread by thomas | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.