Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DURGESH
Posting Yak Master
105 Posts |
 Posted - 2008-06-27 : 00:10:14
|
| hi all,good morningi am getting following error when using substring functionServer: Msg 536, Level 16, State 3Invalid length parameter passed to the substring function. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-27 : 00:12:18
|
| Well you've passed an invalid length to the substring function. We can't provide any more details without you giving us more information.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-06-27 : 00:12:34
|
meaning one of the parameter you pass to the substring is < 0
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
DURGESH
Posting Yak Master
105 Posts |
Posted - 2008-06-27 : 02:12:12
|
| the string passing to the substring function is not properly enclosed in a quoteseg @str='str1','str2'correct string:@str='str1'',''str2' |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-27 : 02:19:46
|
quote:
Originally posted by DURGESH
the string passing to the substring function is not properly enclosed in a quoteseg @str='str1','str2'correct string:@str='str1'',''str2'
Are you telling that this caused the error? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-06-27 : 09:41:03
|
quote:
Originally posted by DURGESH
the string passing to the substring function is not properly enclosed in a quoteseg @str='str1','str2'correct string:@str='str1'',''str2'
Post the full code that caused the errorMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
invalid length parameter passed to the substring