convert - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

convert

Author

Topic

DENIZ3E
Yak Posting Veteran

56 Posts

Posted - 2005-04-18 : 13:49:47

hý everybody,
I WANT TO VARCHAR CONVERT TO FLOAT BUT...

SELECT CONVERT(FLOAT,REPLACE('P1*100','P1','1000'))

'Server: Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to float.

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2005-04-18 : 14:07:11

answered here:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=48554

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources