create function SubStr(@a varchar(10))
returns varchar(1)
as
begin
declare @b varchar(1)
declare @i smallint
set @i=1
set @b= substring(@a,@i,1)
return @b
end
GO
select dbo.SubStr('test')
returns varchar(1)
as
begin
declare @b varchar(1)
declare @i smallint
set @i=1
set @b= substring(@a,@i,1)
return @b
end
GO
select dbo.SubStr('test')
declare @b varchar(1)
declare @i smallint
set @i=1
if @a is not null and @a<>''
set @b= substring(@a,@i,1)
else
set @b=NULL
declare @i smallint
set @i=1
select @b= substring(@a,@i,1) where @i>1
declare @i smallint
set @i=1
select @b= substring(@a,@i,1) where @i>1