sql Like statement

[Shobin_Mathew]

how can i get all records starting with % ?

[Dan_Bracuk]

Does your db have string functions?

[aliaspooryorik]

This works for SQL server:
select * from tablename where Left(myfield, 1) = '%'

[paross1]

Something that I found here ( SQL Tutorial) might help:

The optional ESCAPE sub-clause specifies an escape character for the pattern, allowing the pattern to use '%' and '_' (and the escape character) for matching. The ESCAPE value must be a single character string. In the pattern, the ESCAPE character precedes any character to be escaped.
For example, to match a string ending with '%', use:

x LIKE '%/%' ESCAPE '/'

..or here Using SQL Escape Sequences

... or here How to escape a wildcard in an SQL order with ORACLE.

Phil