SQLServerCentral » Programming » General » "\1" in a formula (Translating MSAccess to T-SQL)InstantForum 2016-2 FinalSQLServerCentralhttps://www.sqlservercentral.com/Forums/SQLServerCentralSun, 22 Jan 2017 18:40:24 GMT20"\1" in a formula (Translating MSAccess to T-SQL)https://www.sqlservercentral.com/Forums/FindPost1414613.aspxWell 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
Fri, 01 Feb 2013 06:28:02 GMTSim-473257RE: "\1" in a formula (Translating MSAccess to T-SQL)https://www.sqlservercentral.com/Forums/FindPost1414641.aspxSo simple, am kicking myself !
Many thanks for that, and the included link.
:)
Fri, 01 Feb 2013 06:28:02 GMTSim-473257RE: "\1" in a formula (Translating MSAccess to T-SQL)https://www.sqlservercentral.com/Forums/FindPost1414630.aspxThis is used to convert the column value to an integer, also called "integer division".
[url=http://office.microsoft.com/en-001/access-help/table-of-operators-HA010235862.aspx]Table of operators[/url]
Since you are dividing by 1, this is basically a shorthand to convert the value column to integers.Fri, 01 Feb 2013 06:15:43 GMTKoen Verbeeck