Skip to Content
0
Former Member
Nov 30, 2005 at 10:36 AM

SQL stmt with LIKE and variable!

3183 Views

I would like to use a SQL stmts like this:

SELECT * FROM tab WHERE key1 LIKE '%<i>variable</i>%'.

Using LIKE in the WHERE clause requieres a character field. But I want to use a vairable...

how should i write that?

thx,

holger