SUBSTRING(str_col, PATINDEX('%[^0]%', str_col+'.'), LEN(str_col))
More Related Contents:
- Is it possible to write single query on two table which are not connected to each other?
- How can I do an UPDATE statement with JOIN in SQL Server?
- SQL update query using joins
- How to update two tables in one statement in SQL Server 2005?
- Referring to a Column Alias in a WHERE Clause
- SQL query to select dates between two dates
- Convert Month Number to Month Name Function in SQL
- Create a date from day month and year with T-SQL
- Selecting COUNT(*) with DISTINCT
- How to return multiple values in one column (T-SQL)?
- Generate a resultset of incrementing dates in TSQL
- Getting result of dynamic SQL into a variable for sql-server
- How to get difference between two rows for a column field?
- SQL – Subtracting a depleting value from rows
- How to print VARCHAR(MAX) using Print Statement?
- What’s the best way to select the minimum value from several columns?
- Concatenate values based on ID
- Splitting delimited values in a SQL column into multiple rows
- SELECT FOR UPDATE with SQL Server
- varbinary to string on SQL Server
- SQL Server 2005 ROW_NUMBER() without ORDER BY
- How to split string using delimiter char using T-SQL?
- Can an INNER JOIN offer better performance than EXISTS
- OPENXML with xmlns:dt
- SQL server select distinct rows using most recent value only
- Eliminate and reduce overlapping date ranges
- Cumulative Total in MS Sql server [duplicate]
- Why do SQL Server Scalar-valued functions get slower?
- Memory effective way to read BLOB data in C#/SQL 2005
- When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?