Can Table Transformer treat numbers in a column as text when trying to filter or sort?

[Alan Lambert]

I have a table that contains software version numbers e.g. 1.0, 2.1, 3.1.1

As you can see, sometimes the data can be interpreted as a number (2.1), and sometimes it can't (3.1.1).

When filtering the SQL using this column I am getting no rows being returned and when sorting by this column version numbers are getting mixed up. I assume that the data is being interpreted as a number. I've tried explicitly converting to a string, but I'm still not getting data back.

e.g.

SELECT T1.'Feature' FROM T1
WHERE T1.'Version' = '1.0'

or

SELECT T1.'Feature' FROM T1
WHERE (T1.'Version'::string) = '1.0'

[Stiltsoft support · Accepted solution]

Hi @Alan Lambert ,

You may try the following option:

SELECT * FROM T1
WHERE TEXT('Version') = "1.0"

Please note that we use 'Column_name' but "Some_value". The quotes differ in the AlaSQL library on which the macro is built.

[Alan Lambert]

Thank you