Re: Syntax help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Warren Brunk" <wbrunk@xxxxxxxxxxxxxxxxxxxx>
Date: Fri, 21 Dec 2007 10:10:05 -0800

Good point.

select Left(column1,charIndex('_',Column1) -1) from
dbo.tbl_test

thanks!

--

/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/

<jhofmeyr@xxxxxxxxxxxxxx> wrote in message
news:19ea3129-97f2-4a83-9bba-1f382ec854dc@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Why are you casting CHARINDEX as INT? Isn't the return value an int
anyway?

J

References:
- Syntax help
  - From: AHartman
- Re: Syntax help
  - From: Warren Brunk
- Re: Syntax help
  - From: AHartman
- Re: Syntax help
  - From: jhofmeyr

Prev by Date: Re: Trying to get a SSIS Import wizard package to actually schedule and work.
Next by Date: Problems Passing a Parameter to a Package
Previous by thread: Re: Syntax help
Next by thread: RE: Insert data to table with index
Index(es):
- Date
- Thread