Removing leading zeroes from a field in a SQL statement

by 
select substring(ColumnName, patindex('%[^0]%',ColumnName), 10)

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Get top 1 row of each group
  3. How to calculate age (in years) based on Date of Birth and getDate()
  4. CROSS JOIN vs INNER JOIN in SQL
  5. Convert Month Number to Month Name Function in SQL
  6. Multiple INSERT statements vs. single INSERT with multiple VALUES
  7. Limit on the WHERE col IN (…) condition
  8. Select group of rows that match all items in a list
  9. Add Foreign Key relationship between two Databases
  10. How to print VARCHAR(MAX) using Print Statement?
  11. How to assign an exec result to a sql variable?
  12. Query error with ambiguous column name in SQL
  13. Why (and how) to split column using master..spt_values?
  14. Splitting delimited values in a SQL column into multiple rows
  15. What does =* mean?
  16. SQL: parse the first, middle and last name from a fullname field
  17. Why and when a LEFT JOIN with condition in WHERE clause is not equivalent to the same LEFT JOIN in ON? [duplicate]
  18. SQL Select Upcoming Birthdays
  19. How can I include null values in a MIN or MAX?
  20. Stored procedure that exports data into csv files only exports to one file
  21. Get Start and End Date from Week Number SQL Server
  22. How to get the identity of an inserted row?
  23. Get the last day of the month in SQL
  24. TSQL – How to use GO inside of a BEGIN .. END block?
  25. SQL take just the numeric values from a varchar
  26. SQL Server SELECT INTO @variable?
  27. WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT
  28. Select a column if other column is null
  29. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  30. Date serial in SQL?

Leave a Comment