 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
judahr
Joined: 09 Mar 2007
Posts: 319
Country: United States |
|
 SQL-Custom Assistance-CharIndex |
 |
I frequently forget the parameter order for CharIndex. Rather than "expression1, expression2" may I suggest:
CHARINDEX(CharactersToBeFound varchar, StringToSearch varchar,[start_location] bigint)int
or something similar. I know I can customize on my own, but they've been lost in an upgrade in earlier versions.
|
|
| Thu May 08, 2008 1:16 pm |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
You can change it the way you want. Open SQL Assistant options screen -> DB Options tab -> SQL Server (left side of the screen) -> expand Custom Assistance (right side of the screen) -> Locate CHARINDEX and edit as required.
|
|
| Thu May 08, 2008 2:13 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
PS. Parameter names appear as they are referenced in the db documentation.
|
|
| Thu May 08, 2008 2:14 pm |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
