WHERE Alphanumeric = Numeric

Question

 

All,

 

I'm having trouble with a query where I need to limit a resultset by comparing (using a WHERE clause) a field that is alphanumeric with one that is numeric.  I've tried converting, casting, and case statements, but I either get an overflow error or a big slap on the wrist by SQL Server 2005.  Does anyone have any good solutions to this?  I've been racking my brain for a while now.

 

Thanks for the help!

-Scott Mescall

Answer 1

how about this

 

Select *From yourTable where YourAlphanumerickey=Cast(yournumericcolumn As varchar(20))

 

Post back the exact error and if possible query

 

Madhu

Answer 2

Yes, I think that's going to work just fine.  Sometimes you just need another set of eyes...

 

Thanks!

-Scott