Create function getBytesubstring (@str var) Returns varchar (8000) asbegin declare @i int exec master..np_getmbcscharlen @ Str, @ le, @ i out if @i is not null set @ str = left (@ Str, @ i) Return (@str) End
