InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 12:24:59 GMT20http://www.sqlservercentral.com/Forums/Topic1414613-23-1.aspxSo simple, am kicking myself !Many thanks for that, and the included link.:)Fri, 01 Feb 2013 06:28:02 GMTSim-473257http://www.sqlservercentral.com/Forums/Topic1414613-23-1.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 Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1414613-23-1.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 ThanksFri, 01 Feb 2013 05:56:43 GMTSim-473257