Category
Data Sources
Product Version
7.3
How to display only records that have numbers in column
Answered
Hi,
Hope things are going alright.
I'd like to know if there is a way to display only records that have numbers in field values?
Example:
Tag Number (Field)
GS356785
MW26598
1234567
987654
TSD58896
1234HG22
1234
From the 'Tag Number' Field above, I'm interested to only see Tag numbers which are numbers
Tag Number
1234567
987654
1234
Appreciate your feedback.
Thank you,
Chakra
The same question
Anything for me please?
Anything for me please?
Hi Chakra,
Your best bet would be some sort of free-hand statement, where you check to see if the value can be casted as a number:
https://stackoverflow.com/questions/14719760/sql-server-check-to-see-if-cast-is-possible
Hope this helps.
Regards,
Nathan
Hi Chakra,
Your best bet would be some sort of free-hand statement, where you check to see if the value can be casted as a number:
https://stackoverflow.com/questions/14719760/sql-server-check-to-see-if-cast-is-possible
Hope this helps.
Regards,
Nathan
Thank you Nathan. This is helpful.
Thank you Nathan. This is helpful.
No problem!
No problem!
Replies have been locked on this page!