Hello - I have a field that stores an ID that can be numeric or an alpha code.
I'm trying to find a way to remove leading 0's for the field if it is a numeric code.
For example, the field values can be as follows:
I have an expression that worked in MS Access, but when I try to apply the code in SQL Server, it does not work.
Example of expression that works in MS Access; IIF(IsNumeric([ID]),INT([ID]),[ID]).
Any thoughts on how to recreate this functionality in SQL Server?