I want to select all the rows whose field myfield starts with %, but I don't

know how to construct the SQL statement.

How can I scape the character %?

And other character's like ^, -, ...?

I only know to scape '  => ''





strSQL = "Select * FROM mytable WHERE myfield LIKE ...

...'\%%'    ?

...  ?



Thanks in advance.



Gonzalo Ruiz de Villa Suárez

Adesis Netlife

Tel. (+34) 915 699 113

Fax. (+34) 915 655 050

e-mail: gonzalo.ruizdevilla@a...

URL: http://www.adesis.com