Binaryworld - Scalar Function Example. ... [ SQL Server -> User Defined Function ]

This sample shows several ways to call a scalar function in T-SQL.

use pubs
go
create function test ( @ci char( 1 ) )
returns bit
as
begin
     return( CASE WHEN NULLIF( @ci , space( 1) ) is not null then 0 else 1 end )
end
go

declare @ci char( 1 ) , @y bit
set @ci =' '
-- Call using EXECUTE
exec @y = test @ci
select @y as IsBlank
/*
IsBlank
-------
   1
*/

set @ci ='A'
-- Call as a function using SET
set @y = dbo.test( @ci )
select @y as IsBlank
/*
IsBlank
-------
   0
*/

set @ci ='b'
-- Call as a function using SELECT
select @y = dbo.test( @ci )
select @y as IsBlank
/*
IsBlank
-------
   0
*/

set @ci ='V'
-- Call a similar system function
set @y = fn_chariswhitespace( @ci )
select @y as IsBlank
/*
IsBlank
-------
   0
*/