conversion to int

rgb192
rgb192 used Ask the Experts™
on
Conversion failed when converting the varchar value '77.95' to data type int.

if I cant use int, what datatype should i use
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Consultant
Top Expert 2009
Commented:
numeric (10,2 )  or decimal (10,2)
Awarded 2008
Awarded 2008
Commented:
cast('77.95' as decimal)
OR
cast('77.95' as money)

Author

Commented:
thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial