Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transferring character field into numeric field
Message
 
 
To
22/10/2012 08:53:26
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01555436
Message ID:
01555447
Views:
55
This message has been marked as a message which has helped to the initial question of the thread.
>Ok, this is just to let you know that I have adjusted a syntax error in the command. The designer accepts the syntax and it is now executing.
>
>Thanks

ISNUMERIC function can give you false positives.

If you want to filter all non-numbers, use
WHERE Column NOT LIKE '%[^0-9]%' -- double negative
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform