"\1" in a formula (Translating MSAccess to T-SQL)
-
Well I feel dumb asking this, but I've Googled my fingertips off ...
I have been given some SQL from MSAccess, and asked to translate it to T-SQL.
One of the expressions selected is "Select [value]\1 as [Field1]"
Does anyone have any idea what the "\1" is meant to do ?
Unfortunately it seems I can find out how to build half an atom bomb on google, but something as simple as a "\" ... is beyond me
Many Thanks
-
This is used to convert the column value to an integer, also called "integer division".
Since you are dividing by 1, this is basically a shorthand to convert the value column to integers.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
So simple, am kicking myself !
Many thanks for that, and the included link.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply