February 1, 2013 at 5:56 am
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
February 1, 2013 at 6:15 am
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
February 1, 2013 at 6:28 am
So simple, am kicking myself !
Many thanks for that, and the included link.
🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply