Hello,
I have a table TABLE where there is a column with data of INTEGER type. The first character of that number identifies a certain type I need in my queries.
Eg.: All the number starting with 5 are representing error occuring when using the printer. I want to make a statistical query listing all the printer errors. So my query would look like:
SELECT * FROM TABLE WHERE ID LIKE 5* (or '5*') ;
It performs the query but returns NULL, however there should be at least a couple of results. My guess is that LIKE can be used only with data of STRING type, so what should I do then? Is there a function to convert numeric data to a STRING? And then how should I use that?
Any help is greatly appreciated as I'm in a hurry.
Thanks, Akos
I have a table TABLE where there is a column with data of INTEGER type. The first character of that number identifies a certain type I need in my queries.
Eg.: All the number starting with 5 are representing error occuring when using the printer. I want to make a statistical query listing all the printer errors. So my query would look like:
SELECT * FROM TABLE WHERE ID LIKE 5* (or '5*') ;
It performs the query but returns NULL, however there should be at least a couple of results. My guess is that LIKE can be used only with data of STRING type, so what should I do then? Is there a function to convert numeric data to a STRING? And then how should I use that?
Any help is greatly appreciated as I'm in a hurry.
Thanks, Akos