Microsoft SQL Server Query Features: Difference between revisions
Jump to navigation
Jump to search
(Created page with "===trim=== ltrim rtrim select trim(address1) from Customer ===concat=== ===replace=== Replace singele quote with 2 single quotes: <code>replace(rtrim(ltrim(NAME)),'''','''''') "DRIVER_NAME",</code> ===left, right=== ===case=== ===iif=== ===windowing functions=== ===rank=== ===derived queries=== Derived queries, fequently seen as a "with" statement... allow for querying queries.") |
(→trim) |
||
| Line 1: | Line 1: | ||
===trim=== | ===trim=== | ||
ltrim rtrim | Commands: trim, ltrim, rtrim | ||
The trim commands will trim spaces from the beginning and end of strings. | |||
select trim(address1) from Customer | In older MS SQL you must use ltrim and rtrim together to trim both ends of a string... | ||
<code>select rtrim(ltrim(address1)) from Customer</code> | |||
Modern MS SQL allows for just trim... | |||
<code>select trim(address1) from Customer</code> | |||
===concat=== | ===concat=== | ||
Revision as of 16:20, 27 February 2024
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
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.