Try_Convert for SQL Server 2008 R2

by

When using XML in SQL Server you can try to cast to a data type and receive null values where the cast fails.

declare @T table
(
  Col varchar(50)
)

insert into @T values
('1'),
('1.1'),
('1,1'),
('1a')

select cast('' as xml).value('sql:column("Col") cast as xs:decimal ?', 
                             'decimal(28,10)') as Col
from @T

Result:

Col
-------------
1.0000000000
1.1000000000
NULL
NULL

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Default row order in SELECT query – SQL Server 2008 vs SQL 2012
  3. Convert Date format into DD/MMM/YYYY format in SQL Server
  4. How to subtract 30 days from the current date using SQL Server
  5. Cannot Resolve Collation Conflict
  6. SQL Server: +(unary) operator on non-numeric Strings
  7. How to automatically generate unique id in SQL like UID12345678?
  8. Efficiently convert rows to columns in sql server
  9. How can I get column names from a table in SQL Server?
  10. How can I select the first day of a month in SQL?
  11. T-SQL – Insert Data into Parent and Child Tables
  12. Select statement to find duplicates on certain fields
  13. Identity column value suddenly jumps to 1001 in sql server [duplicate]
  14. Using a Variable in OPENROWSET Query
  15. How to find current transaction level?
  16. EXISTS vs JOIN and use of EXISTS clause
  17. Count Number of Consecutive Occurrence of values in Table
  18. Check for file exists or not in sql server?
  19. Group DateTime into 5,15,30 and 60 minute intervals
  20. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  21. Which SQL query is faster? Filter on Join criteria or Where clause?
  22. UPDATE and REPLACE part of a string
  23. Improve SQL Server query performance on large tables
  24. Select SQL Server database size
  25. Backup a single table with its data from a database in sql server 2008
  26. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  27. COALESCE Function in TSQL
  28. How to get Previous Value for Null Values
  29. Display next event date
  30. Sql query for tree table

Leave a Comment