Want to include a (currently) small SQL file with a CPP program. The line:
WHERE type LIKE : parameter AND [number] > 0
The 'parameter' (the space is there because I get a smiley otherwise) is supplied by text in a text field but I want to concatanate the any or no character '%' to either side of the parameter. Unfortunately i've completely lost it and no combination of ', ", or , produces anything other than an error.
What is the syntax?
Cheers


LinkBack URL
About LinkBacks
Reply With Quote

You've helped me get back to exactly where I was 3 weeks ago
