The table I'm searching is varchar. The entries I'm interested in are only numeric. But for some reason there's mixed string/int entries. How can I chose only the numeric values?
Questor 0 Newbie Poster
Recommended Answers
Jump to Postpty is right. this should do it for you
select * from tablename where isnumeric(columnname) = 1
All 4 Replies
pty 882 Posting Pro
i dont use SQL Server much these days, but is there not a isNumber() or isNumeric() function?
If there isn't im sure writing your own wouldnt be that difficult. Just attempt to cast a varchar as a number and if it succeeds its a number. If it doesnt, it aint.
The 'real' solution to this is to fix your database so that text data is stored in char/varchar fields and numeric data is stored in the appropriate numeric type.
campkev 0 Posting Pro in Training
pty is right. this should do it for you
select * from tablename where isnumeric(columnname) = 1 Questor 0 Newbie Poster
That worked, thank you!
campkev 0 Posting Pro in Training
de nada
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.