Microsoft SQL Server Query Features
trim
Commands: trim, ltrim, rtrim The trim commands will trim spaces from the beginning and end of strings.
In older MS SQL you must use ltrim and rtrim together to trim both ends of a string...
select rtrim(ltrim(address1)) from Customer
Modern MS SQL allows for just trim...
select trim(address1) from Customer
Concat
Use concat instead of the "||" characters used in Interbase to concatenate.
Example...
CONCAT('Acct Cat Code: ',RTRIM(LTRIM(ACCT_CAT_CODE))) USER_2,
replace
Replace singele quote with 2 single quotes:
replace(rtrim(ltrim(NAME)),',') "DRIVER_NAME",
left, right
case
iif
windowing functions
rank
derived queries
Derived queries, fequently seen as a "with" statement... allow for querying queries.