Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How convert 20k sal into 20,000 in sql server
You can use the SQL replace function
SELECT REPLACE('20k', 'k', ',000');
or
SELECT REPLACE('20k sal', 'k sal', ',000');
sal is column name
actualdata requirment
sal sal
20k 20,000
10k 10,000
12k 12,000
SELECT REPLACE(sal, 'k', ',000') as sal from table1
no i did't get it
Use following in your load script in qlikview or sense:
load REPLACE(sal, 'k', '000') as sal from database.tablename
Hi, srinu:
1- option:
LOAD *, KeepChar(sal,'0123456789')*1000 as FieldSal;
LOAD * Inline
[
sal
10k
20k
30k
];