ABS and SubStrings:
select ABS(amount) from Amount where Name = ‘Usman Mughal’
select abs(-98)
select SUBSTRING(‘muhammad usman ali’,1,7) ‘name’
list ‘%atm%transaction%’
Account Panal Shows in One Column
SELECT LTRIM(RTRIM(CONVERT(CHAR(1),Country))) + “-” +
LTRIM(RTRIM(CONVERT(CHAR(2),Zone))) + “-” +
LTRIM(RTRIM(CONVERT(CHAR(2),Branch))) + “-” +
LTRIM(RTRIM(CONVERT(CHAR(5),subhead))) + “-” +
LTRIM(RTRIM(CONVERT(CHAR(3),currency)))+ “-” +
LTRIM(RTRIM(CONVERT(CHAR(6),account))) ‘Debit Account’ ,
select ABS(amount) from Amount where Name = ‘Usman Mughal’
select abs(-98)
select SUBSTRING(‘muhammad usman ali’,1,7) ‘name’
list ‘%atm%transaction%’
SELECT LTRIM(RTRIM(CONVERT(CHAR(1),Country))) + “-” +
LTRIM(RTRIM(CONVERT(CHAR(2),Zone))) + “-” +
LTRIM(RTRIM(CONVERT(CHAR(2),Branch))) + “-” +
LTRIM(RTRIM(CONVERT(CHAR(5),subhead))) + “-” +
LTRIM(RTRIM(CONVERT(CHAR(3),currency)))+ “-” +
LTRIM(RTRIM(CONVERT(CHAR(6),account))) ‘Debit Account’ ,
SQL Functions..
SQL Functions
escape_name map_string
abs abs(%1)
acos acos(%1)
asin asin(%1)
atan atan(%1)
atan2 atn2(%1, %2)
ceiling ceiling(%1)
cos cos(%1)
cot cot(%1)
degrees degrees(%1)
exp exp(%1)
floor floor(%1)
log log(%1)
log10 log10(%1)
pi pi()
power power(%1, %2)
radians radians(%1)
rand rand(%1)
round round(%1, %2)
sign sign(%1)
sin sin(%1)
sqrt sqrt(%1)
tan tan(%1)
ascii ascii(%1)
char char(%1)
concat %1 + %2
difference difference(%1, %2)
insert stuff(%1, %2, %3, %4)
length char_length(%1)
lcase lower(%1)
ltrim ltrim(%1)
repeat replicate(%1, %2)
right right(%1, %2)
rtrim rtrim(%1)
soundex soundex(%1)
space space(%1)
substring substring(%1, %2, %3)
ucase upper(%1)
curdate getdate()
curtime getdate()
dayname datename(dw, %1)
dayofmonth datepart(dd, %1)
dayofweek datepart(dw, %1)
dayofyear datepart(dy, %1)
hour datepart(hh, %1)
minute datepart(mi, %1)
month datepart(mm, %1)
monthname datename(mm, %1)
now getdate()
quarter datepart(qq, %1)
second datepart(ss, %1)
timestampaddsql_tsi_second dateadd(ss, %2, %3)
timestampaddsql_tsi_minute dateadd(mi, %2, %3)
timestampaddsql_tsi_hour dateadd(hh, %2, %3)
timestampaddsql_tsi_day dateadd(dd, %2, %3)
timestampaddsql_tsi_week dateadd(wk, %2, %3)
timestampaddsql_tsi_month dateadd(mm, %2, %3)
timestampaddsql_tsi_quarter dateadd(qq, %2, %3)
timestampaddsql_tsi_year dateadd(yy, %2, %3)
timestampdiffsql_tsi_second datediff(ss, %2, %3)
timestampdiffsql_tsi_minute datediff(mi, %2, %3)
timestampdiffsql_tsi_hour datediff(hh, %2, %3)
timestampdiffsql_tsi_day datediff(dd, %2, %3)
timestampdiffsql_tsi_week datediff(wk, %2, %3)
timestampdiffsql_tsi_month datediff(mm, %2, %3)
timestampdiffsql_tsi_quarter datediff(qq, %2, %3)
timestampdiffsql_tsi_year datediff(yy, %2, %3)
week datepart(wk, %1)
year datepart(yy, %1)
database db_name()
ifnull isnull(%1, %2)
user user_name()
convertsql_binary convert(varbinary(255), %1)
convertsql_bit convert(bit, %1)
convertsql_char convert(varchar(255), %1)
convertsql_date convert(datetime, %1)
convertsql_decimal convert(decimal(36, 18), %1)
convertsql_double convert(float, %1)
convertsql_float convert(float, %1)
convertsql_integer convert(int, %1)
convertsql_longvarbinary convert(varbinary(255), %1)
convertsql_longvarchar convert(varchar(255), %1)
convertsql_real convert(real, %1)
convertsql_smallint convert(smallint, %1)
convertsql_time convert(datetime, %1)
convertsql_timestamp convert(datetime, %1)
convertsql_tinyint convert(tinyint, %1)
convertsql_varbinary convert(varbinary(255), %1)
convertsql_varchar convert(varchar(255), %1)
locate charindex ((convert (varchar, %1)), (convert (varchar, %2)))
character_length char_length(%1)
char_length char_length(%1)
octet_length octet_length(%1)
current_date current_date()
curtime current_time()
current_time current_time()
current_timestamp getdate()