[V4RB2] What's wrong with SQLSelect?

[Ivan Smahin]

Hello Ruslan,

Wednesday, March 30, 2005, 12:08:28 PM, you wrote:

RZ> On 3/29/05 10:19 PM, "Kem Tekinay"
RZ> <ktekinay at mactechnologies.com> wrote:

>>> Now I set find = "NY", making the SQL command:
>>> 
>>>  SELECT * FROM Zip_Codes WHERE Zip_Code LIKE 'NY%' OR City LIKE 'NY%'
>>>     OR State LIKE 'NY%'
>> 
>> And here is where the problem is. My e-mail reads like the above, but, in
>> actuality, my select command read like this:
>> 
>>   SELECT * FROM Zip_Codes WHERE Zip_Code LIKE 'ny%' OR City LIKE 'ny%'
>>      OR State LIKE 'ny%'


BTW, you can use 'RegEx' engine instead of 'Like'.
It can be something like this:

SELECT *
FROM
    Zip_Codes
WHERE
     Zip_Code RegEx '(?i)ny'
...


-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua