"\1" in a formula (Translating MSAccess to T-SQL)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Programming » General » "\1" in a formula (Translating MSAccess to...

"\1" in a formula (Translating MSAccess to T-SQL)

Rate Topic

Display Mode

Topic Options

Author

Message

Sim-473257

Posted Friday, February 01, 2013 5:56 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 22, 2013 7:58 AM
Points: 17, Visits: 76

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 Sad

Many Thanks

Post #1414613

Koen Verbeeck

Posted Friday, February 01, 2013 6:15 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 9,378, Visits: 6,473

This is used to convert the column value to an integer, also called "integer division".

Table of operators

Since you are dividing by 1, this is basically a shorthand to convert the value column to integers.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1414630

Sim-473257

Posted Friday, February 01, 2013 6:28 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 22, 2013 7:58 AM
Points: 17, Visits: 76

So simple, am kicking myself !

Many thanks for that, and the included link.

:)

Post #1414641

« Prev Topic | Next Topic »

Permissions