Re: Re-writing sql code using another column to get same result

[Phillip Ward]

Possible? Sure.
Performant? Not so much.

You're calling a function on a field value and the only way the database can work out what the result is going to look like is to call it for each and every row in turn, i.e. your query is going to Table Scan and, for data of any real size, your application will slow to a crawl.

Store your data in the right Data Types.

Regards, Phill W.