SQL String Question

[Roland Farkas]

> on 5/7/03 5:55 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?

Roland