main logo
Subject: whole word with sql function
Author: "Carlo Sacchetti"
Posted: 2002/06/29 11:03:33
 
View Entire Thread
New Search


This is a multi-part message in MIME format.

------=_NextPart_000_0005_01C21F97.4836AA20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Ruslan,
Thanks a lot for all. I resolve all problem for my job but I have one =
too (I hope the last). If I use the function locate ('bar','mybar') with =
lower()I resolve the probleme with case sensitive or not word but it =
remain a problem for whole word or not. If I search with function =
"locate" I find al word also a part of word. For exemple =
locate('reg','correge') is ok and the result is 4. But if I have a =
clause only whole word? Is a problem. Is there a function like lower() =
also for this problem.
Thanks
Carlo Sacchetti

------=_NextPart_000_0005_01C21F97.4836AA20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi Ruslan,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Thanks a lot for all. I resolve all =
problem for my=20
job but I have one too (I hope the last). If I use the function locate=20
('bar','mybar') with lower()I resolve the probleme with case sensitive =
or not=20
word but it remain a problem for whole word or not. If I search with =
function=20
"locate" I find al word also a part of word. For exemple =
locate('reg','correge')=20
is ok and the result is 4. But if I have a clause only whole word? Is a =
problem.=20
Is there a function like lower() also for this problem.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Carlo =
Sacchetti</FONT></DIV></BODY></HTML>

------=_NextPart_000_0005_01C21F97.4836AA20--


------=_NextPart_000_0005_01C21F97.4836AA20
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
 
©2002 Carlo Sacchetti
<-- Prior Message New Search Next Message -->