Is there a function like SUBSTRING but for integers?

Hot Topic

Default Parameter Trouble\Question
SQL Server 2000 and 2005 Compatibility
if/else newbie question (conditionalizing SELECT on old/new db, existence/abscence of a column)
Custom ControlFlow
TRACE FREEZES CURRENT CONTEXT
cannot install express edition
Versioning Stored Procedures with VSS and Sql Server 2005
Does the Sql Server 2005 EVAL distribution support run of packages under DtExec?
Bug? Err Rows Not Filtering on truncation in delimited file types
Strange problem about report export formats

SQL Server

OTP: help
Changing page size
Empty Source So there is no data in the pipleline
Programmatically creating .csv file
Update SQL Server 2005 Install files
define number of rows returned from query
ODBC data flow source
Sql Server 2005 (32 Bit)
query builder
memory could not be read

Is there a function like SUBSTRING but for integers?

I'm wondering if there is a function in SQL that works like SUBSTRING function but for integers. Like for example if I have a number like 20010112 and I want to cut it to the first for digits so that it reads 2001


Answer this question

Is there a function like SUBSTRING but for integers?

  • FunkeyMonkey

    You use LEFT function.

    SELECT LEFT(20010112, 4)

    You should get 2001

    This function works on string too.

  • losoriomx

    this left function is for string. if you pass in a integer, the integer value is implicit convert to string
    so 20010112 is converted to '20010112'.

    You can convert the integer to string before using substring

    substring(convert(varchar(10), @intvar), 5, 2)


  • Is there a function like SUBSTRING but for integers?
Answer this question