Microsoft SQL Server Query Features

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

Use concat instead of the "||" characters used in Interbase to concatenate.

Example... CONCAT('Acct Cat Code: ',RTRIM(LTRIM(ACCT_CAT_CODE))) USER_2,

Replace singele quote with 2 single quotes: replace(rtrim(ltrim(NAME)),',') "DRIVER_NAME",

Similar to using a case statement, iif gives allows you 2 responses to an if condition..

iif(rtrim(LTRIM(INACTIVE_CODE))='00','Y','N') active_flag,

Derived queries, fequently seen as a "with" statement... allow for querying queries.

Contents