SQL String Question

[Ruslan Zasukhin]

on 5/7/03 9:59 PM, Roland Farkas at roland at mindmedia.de wrote:

>>> Hi,
>>> 
>>> Can anyone help me with this.
>>> 
>>> That´s the string: select * from main where kennung like '\A3.2.5.1.1.' no
>>> case
>>> 
>>> And this is one of the results: 3.2.5.1.10
>>> 
>>> This should not happen. Is this because of the dot? Special Character? How
>>> can I get this working?
>> 
>> Hi Roland,
>> 
>> Yes, this is because of dot.
>> 
>> Please check RegEx docs.
>> DOT means -- ANY SYMBOL.
>> 
>> When you do such search and you WANT find dots, you need to escape them.
>> In fact your query above will be able find e.g. "3-2-5-1-1" also
>> 
> 
> Hi Ruslan,
> 
> Thanx for the answer. Do you have a solution for that in mind?

You need escape your dots in query.
then regEx will consider them as real dots.

    select * from main where kennung like '\A3\.2\.5\.1\.1\.'


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------