SQL String Question

[Ruslan Zasukhin]

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


-- 
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
-------------------------------------------------------------