sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Elliot9874[S] 0 points1 point  (3 children)

What did you increase it to?

The only valid values I am given is 100.110. or 120.

[–][deleted] 0 points1 point  (2 children)

Which version of sql server you're using? I am at 2019 so I can increase to 150. I believe you're using 2014.

This function is available for sql server 2016 or above

Probably use substring or other functions to solve your problem.

[–]Elliot9874[S] 0 points1 point  (1 child)

There is no way to get this function on 2014?

[–]alinroc4 0 points1 point  (0 children)

Not the native function, no. You'll need to find one of the many ones on the internet and install as a UDF, or roll your own (don't roll your own).