GIJoeFigure
Technical User
Hello all, I was wondering if I was to make a query def with this SQL statement, how would I do it correctly?
I would like to format the 'rows' column as all numbers but it is currently a text column and too hard to set as number format. I read a posting of a similar problem but I'm sure I'm missing something since I keep getting error messages saying this query's function will retrieve one response. Can the format SQL function change each field entry to number format? Please help!
Code:
SELECT * FROM sampletable WHERE (SELECT FORMAT([Rows],0000) FROM sampletable) < 800
I would like to format the 'rows' column as all numbers but it is currently a text column and too hard to set as number format. I read a posting of a similar problem but I'm sure I'm missing something since I keep getting error messages saying this query's function will retrieve one response. Can the format SQL function change each field entry to number format? Please help!