How to convert the float datatype to string

Question

Using sql server 2000

Table1

id value (float)

001 10.00
002 
003 
004 08.50
...

i want to check the value column, if is null then display 'NA'

Tried Query

Select id,
CASE WHEN value  IS NULL then '-' else value end  AS value
from table1

'

Select id,
isnull(value, '-') AS value
from table1

Both query showing error as "Error converting data type varchar to float."

How to solve this issue.

need query help

podiluska · Accepted Answer · 2012-08-28 08:22:20Z

3

Select id, 
isnull(convert(varchar(20),value), '-') AS value 
from table1

answered Aug 28, 2012 at 8:22

podiluska

51.6k7 gold badges102 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

John Woo · Accepted Answer · 2012-08-28 08:22:52Z

1

Try

SELECT id, CAST(COALESCE(value, 'NA') as VARCHAR(25)) as [Value]
FROM tableName

answered Aug 28, 2012 at 8:22

John Woo

265k70 gold badges509 silver badges500 bronze badges

Comments

mehdi lotfi · Accepted Answer · 2012-08-28 08:29:11Z

0

use below query :

SELECT id, ISNULL( CAST(value as VARCHAR(25)), 'NA')) as [Value]
FROM tableName

answered Aug 28, 2012 at 8:29

mehdi lotfi

11.6k18 gold badges85 silver badges128 bronze badges

Comments

AnandPhadke · Accepted Answer · 2012-08-28 10:00:15Z

0

select id,cast(isnull(value,'') as varchar(10)) from table

answered Aug 28, 2012 at 10:00

AnandPhadke

13.5k5 gold badges28 silver badges34 bronze badges

Collectives™ on Stack Overflow

How to convert the float datatype to string

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related