Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Transferring character field into numeric field
Message
 
 
À
22/10/2012 08:53:26
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01555436
Message ID:
01555447
Vues:
54
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform