Ron
I do believe that placing a space in '%$var %' will do the same as a
varchar and sprip it off the end. Not positive. However I believe
something like this will do the trick:
SELECT something
FROM a_file
WHERE replace(CONCAT_WS('','.',a_file.field,'.'),' ','.') LIKE '%.$var.%'
HTH... Dan
Ron Wallace wrote:
thanks, helpers, but I think I have a simple solution:
I will insert a space at the front of the string,
where the db must accept and retain it.
BTW, here is the SQL I am working with:
//
elseif ($desc==desc) {
$sql=SELECT