all groups > sql server mseq > october 2004 >
You're in the

sql server mseq

group:

Text Search


Text Search Ibrahim Awwad
10/3/2004 1:35:02 AM
sql server mseq: Dear All,
I have table for items, some of the Items codes are including text codes.
When I try to use
Select From **** Where **** like '****'

I don't get the correct record until I put the Upper case or lower case text
corrosponding to What's in table.
EX. to look for 'DISCOUNT' i can't give him 'discount' I should write it as
it's.

Is there any solution.

--
*********
IT Manager
DeLaval Ltd.
Cairo-Egypt
*********
|-----------------------------|
|Islam is peace not Terror|
RE: Text Search Yaocuauhtzin
10/7/2004 6:17:02 AM
Your Database was created with 'case sensitive' option. To change to 'case
insensitive', you must re-created the Database, I think.

Also, you can try:

Select From **** Where upper(****) like upper('****')


[quoted text, click to view]
AddThis Social Bookmark Button