Errors and Solutions
Friday, February 22, 2019
[SQL] ISNUMERIC CAST REPLACE
select isnumeric('abc')
0
select isnumeric (100)
1
select cast(23.495 as int)
23
select cast(replace('1234534!!!','!!!','') as int)
1234534
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment