main logo
Subject: no_case with SQL function
Author: "Carlo Sacchetti"
Posted: 2002/06/29 07:32:58
 
View Entire Thread
New Search


This is a multi-part message in MIME format.

------=_NextPart_000_0005_01C21F79.DD1E9CB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Ruslan,
thanks for your help. Finally I resolve the problem with SQL function. =
Now I have another problem. I use the function "locate ('bar','combar'). =
It run very well, but it'is case sensitive. There's a way to make a no =
caseSensitive search with this function, without use another method like =
UPPER(). More word have only one case letter (the first). I try to use =
no_case but not run.
Thanks a lot
Carlo Sacchetti

------=_NextPart_000_0005_01C21F79.DD1E9CB0
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 for your help. Finally I resolve =
the problem=20
with SQL function. Now I have another problem. I use the function =
"locate=20
('bar','combar'). It run very well, but it'is case sensitive. There's a =
way to=20
make a no caseSensitive search with this function, without use another =
method=20
like UPPER(). More word have only one case letter (the first). I try to =
use=20
no_case but not run.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Thanks a lot</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Carlo =
Sacchetti</FONT></DIV></BODY></HTML>

------=_NextPart_000_0005_01C21F79.DD1E9CB0--


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