Atif,

My point was SUBSTRING is 1 based, not 0 based.

DECLARE

@String VARCHAR(50)

SET @String = 'Doug'

PRINT SUBSTRING( @String, 1, 3 )

PRINT SUBSTRING( @String, 0, 3 )

It won't error out - but it will not work correctly either.

Doug