Does anyone know the syntax for pulling data that is "like" a particular format? For example, if I want to pull all course codes with a 0 as the second digit. I know in SQL I would use '%0%%'.This message has been edited. Last edited by: Kerry,
WebFOCUS 7.6 Windows, All Outputs
September 27, 2011, 05:31 PM
Dan Satchell
In WebFOCUS the syntax is:
WHERE field LIKE '_0%';
WebFOCUS 7.7.05
September 27, 2011, 05:46 PM
njsden
Even in SQL you should use exactly the same syntax Dan provided.
'%0%%' would actually retrieve all values with a 0 anywhere in your field. The double % at the end of the expression is also redundant.