SQL Topic

[srinu1331]

How convert 20k sal into 20,000 in sql server

[sibin_jacob]

You can use the SQL replace function

SELECT REPLACE('20k', 'k', ',000');

or

SELECT REPLACE('20k sal', 'k sal', ',000');

[srinu1331]

sal is column name

actualdata          requirment

sal                    sal

20k                    20,000

10k                    10,000

12k                    12,000

[sibin_jacob]

SELECT REPLACE(sal, 'k', ',000') as sal from table1

[arvind1494]

Re: SQL Topic

Hi srevas1331

did you completed this?

[srinu1331]

no i did't get it

[arvind1494]

Use following in your load script in qlikview or sense:

load REPLACE(sal, 'k', '000') as sal from database.tablename

[el_aprendiz111]

Hi, srinu:

1- option:

LOAD *, KeepChar(sal,'0123456789')*1000 as FieldSal;
LOAD * Inline
[
sal
10k
20k
30k
];