Saiko Consulting's SqlChallenge

Home
Why It Works How It Works
Daily Challenge
Challenge Winners Contact

Companies

Recruiter Tools

Post SqlAds

Resume Razor

Candidates

Training

Intro to

Informatica

Top 10

grabowski

vlg

anjugarg

billw

jjahns

drj

nisha

nishardhini

grifman

kalaabhyas

Yesterdays Results
86% Correct
14% Incorrect

Sponsored Jobs

DB2 DBA

New Haven Area, CT

DB2, DBA, Logical & Physical Modeling more...

Project Manager (Multiple)

Windsor, CT

Junior to Senior Level Project Managers with Insurance Background more...

Production Support Analyst - Unix, FTP

Bristol, CT

Momentum, Odin, ConnectDirect, Tidal, BARR, and Tandem application and O/S software more...

IT Analyst (business analyst)

Bristol, CT

documentation, user interaction re: full sdlc responsibility. Security access, full sdlc, post-requirement. more...

Data Modeler

Shelton, CT

UML, Rational, RequisitePro more...

Business Analyst

Windsor, CT

Insurance B/A more...

Data Analyst

Shelton, CT

MSAccess, SQL Sever, SQL, DBase, Clipper, Foxpro more...

Read A Topic

Return To Topics	Originally Posted: 6/12/2006 5:23:50 PM
	Last Updated: 6/12/2006 5:23:50 PM

Subject:

Finding Only Numeric Values In A Column

You Asked....

I am looking for a way to find rows that have only numeric value in a column called TotalDollarAmt.

For example:

123 should return true
abc should return false
456 should return true
$123.456 should return false.

When using the ISNUMERIC function $123.456 still return true because SQL Server casts the value to a number.

Any ideas?

and we responded....

My first thought would be to use the ISNUMERIC function just like you did.

However, like you said $123.456 will be implicity converted to a number.

What we need to do is use a wild card search combined with pattern matching.

Something like this will work

SELECT columnName FROM tableName WHERE columnName LIKE LIKE '%[0-9]%'

others said....

Post Your Own Review