sql convert function - 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

General SQL Server Forums

New to SQL Server Programming

sql convert function

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-06-09 : 08:49:09

chirag writes "


i want to convert datatype numeric to varchar 

my query is 
====================================================
SELECT  ParameterName+' ('+instancename+')' as Item,
CurrentUse as LastPoll,
Threshold + 
case Comparer when 'Greater Than' then '( > )'when 'Less Than' then '( < )'end ,
CASE Status WHEN 'Running' THEN 'N' WHEN 'Stopped' THEN 'Y' END as Breach 
FROM PARAMETER 
======================================================
please solve this query as soon as possible 

at 
chiragvm@gmail.com

nr
SQLTeam MVY

12543 Posts

Posted - 2006-06-09 : 09:05:34

What do you want to convert to varchar?
It's not clear from the query.

maybe Threshold
convert(varchar(100),Threshold)

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-06-09 : 09:23:28

Do this in front end application

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources