sql2008-intercept field function

LTrim () int turn character

Left (' ABC ', 2) = ' AB '

Right (' ABC ', 2) = ' BC '

SUBSTRING (' ABC ') = ' AB ' is the same as copy in Delphi
Substring (' http://www.baidu.com ', CHARINDEX (' www ', ' http://www.baidu.com ') +1,len (' http://www.baidu.com ')) = ' Www.baidu.com '

CONVERT (VARCHAR), GETDATE (), 120)
120 or Yyyy-mm-dd Hh:mi:ss (24h)
121 or Yyyy-mm-dd hh:mi:ss.mmm (24h)  

CAST (' as int ')
Neither the CAST () function nor the CONVERT () function can perform rounding or truncation operations.

Str= ' July 15, 2009 Friday '
PATINDEX ('% Day ', str)--Gets the position of the ' Day ' character in the string, i.e. 10

sql2008-intercept field function