adding '0,' before every column

Question

I'm trying an 0, before every column in my sql

select TemporaryStock * '0,'+ cast( VAT as varchar(50)) from Market

i get error Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to float.

'0,' is not a float value then how it will convert from varchar to float? — Kannan Kandasamy, Sep 28 '16 at 18:43
Really not clear what you are going for. Perhaps some sample data and desired results — John Cappelletti, Sep 28 '16 at 18:44
Text needs to be displayed like that or you need the calculated value of 5*0.24? — Kannan Kandasamy, Sep 28 '16 at 18:52

S3S · Answer 1 · 2016-09-28T19:01:47.937

1

You don't need to cast... you just need to move the decimal.

select TemporaryStock * (VAT * 0.01) from Market

If you want every value to be like 0.###### then you can use:

select TemporaryStock  * convert(decimal(38,37),'0.' + convert(varchar,VAT))

edited Sep 28 '16 at 19:01

answered Sep 28 '16 at 18:52

S3S

score 0 · Answer 2 · edited May 23 '17 at 12:00

0

If you want to add '0' before the VAT then use CONCAT(args1, args2) method:

select CONCAT('0',VAT) from ExpressMarket;

Note: Both the arguments should be of string type.

Or else you can refer the following to know more about how to concatenate and aliasing it.

edited May 23 '17 at 12:00

Community

answered Sep 28 '16 at 18:44

PassionInfinite

OP has SQL Server 2008 tagged not MySQL. `CONCAT()` in SQL Server is only for 2012 onward – S3S Sep 28 '16 at 18:48
I need it for sql server – user6894907 Sep 28 '16 at 18:48

2 Answers2