Trying to Learn Functions Returning Null

• Alan Haase

  Grasshopper

  Points: 19

  More actions

  September 8, 2006 at 2:47 am

  #172475

  I'm trying to figure out how to do a function that can grab a memberID and spit out their Lastname, Firstname together as a nvarchar and my function below gives me NULL values for membername. Can anyone help me?

  USE

  DatabaseName;

  GO

  CREATE

  FUNCTION dbo.MemberName(@RegMemberID varchar(3))

  RETURNS

  nvarchar(42) WITH EXECUTE AS CALLER

  AS

  begin

  DECLARE @fullname nvarchar(42)

  SELECT @fullname = (LastName + ', ' + FirstName)

  FROM dbo.RegisteredMembers

  WHERE @RegMemberID = RegMemberID;

  RETURN @fullname;

  end

  GO

  USE

   DatabaseName

  GO

• Jo Pattyn

  SSC-Dedicated

  Points: 32352

  More actions

  September 8, 2006 at 4:50 am

  #659308

  SELECT @fullname = (ISNULL(LastName,'') + ', ' + ISNULL(FirstName,''))

  NULL+something=NULL

  if there is no RegMemberID it still returns NULL

• Farrell Keough

  SSCoach

  Points: 17414

  More actions

  September 8, 2006 at 2:07 pm

  #659457

  Please do not cross post...

  I wasn't born stupid - I had to study.