SQL query

[Paps2]

Hi all, Why wont my sql query work. It returns with no records. SELECT pkey, description FROM Test WHERE (((test.description) Like 'DEL%')) Yet there is a record with 'DELIVER' in the description col of the Test table. Tnx

[Yulianto]

Try testing it with the SQL builder

---

Work hard and a bit of luck is the key to success.

You don`t need to be genius, to be rich.

[Alex Korchemniy]

Test your query in Query Analyzer. By the way those parenthesis are extra ;) This posting is provided "AS IS" with no warranties, and confers no rights. Alex Korchemniy