Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PurpleOne

    Striping characters

    If you use the Case function you can check for a value of 0 - which means not found - for example select case Charindex(' ', BS.FirstName) when 0 then BS.FirstName else substring(BS.FirstName, 1 , charindex(' ',BS.FirstName)-1) end from tblreportcpresults BS will give you the first name...
  2. PurpleOne

    sql STATEMENT HELP

    check out http://www.sqlservercentral.com - they have several scripts to pivot sql.

Part and Inventory Search

Back
Top