If string_expression is of type binary or varbinary, LEFT will perform an implicit conversion to varchar, and therefore will not preserve the binary input. integer_expression Is a positive integer ...

How to create function for split string in sql function accepts two parameters first the concatenated string and second the delimiter character.create function ... (@delimiter,@string) if @ind !=0 ...