set variable to function result

• L09041975

  Old Hand

  Points: 300

  More actions

  January 27, 2011 at 3:10 pm

  #231163

  How do you set a variable to the results of a function call passing one parameter ie

  declare @MyVariable varchar(50)

  set @MyVariable = MyFunction(@MyParameter)

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  January 27, 2011 at 3:37 pm

  #1279439

  you could try SELECT instead of SET, but I'm curious what error you are getting?

  CEWII

• L09041975

  Old Hand

  Points: 300

  More actions

  January 27, 2011 at 3:58 pm

  #1279450

  set @MyVariable = MyFunction(@MyParameter) and

  select @MyVariable = MyFunction(@MyParameter) gave the following error:

  'MyFunction' is not a recognized built-in function name.

• LutzM

  SSC Guru

  Points: 107049

  More actions

  January 27, 2011 at 4:15 pm

  #1279455

  L09041975 (1/27/2011)

  ---

  set @MyVariable = MyFunction(@MyParameter) and

  select @MyVariable = MyFunction(@MyParameter) gave the following error:

  'MyFunction' is not a recognized built-in function name.

  Did you try to call the function including the schema?

  E.g. select @MyVariable = dbo.MyFunction(@MyParameter)

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

• L09041975

  Old Hand

  Points: 300

  More actions

  January 27, 2011 at 6:34 pm

  #1279470

  Thanks that works.