[RESOLVED] % in SQL statement

[thewalluk]

I was just wondering how i can join % in an SQL statement to allow to search for anything containing. Do i have to concatenate a string?? example:

$Query = "SELECT * FROM $TableName WHERE (photodesc Like '$Search')";

I want to place 2 % before the search term and after it!

TIA

[stolzyboy]

$Query = "SELECT * FROM $TableName WHERE (photodesc Like '%$Search%')";

thats it

[thewalluk]

Cheers this works perfectly. Thanks for your help.