List all Functions ufn_concat RRS feed

  • Question

  • User1203305613 posted

    I have 100 select queries ,some call functions , I want to know how do I list all functions called in a selct query

    Example select ufn_concat(lastname,firstname), dob from table1

    I want this to be listed as ufn_concat.

    Sunday, March 1, 2020 5:16 PM


  • User281315223 posted

    If I understand your correctly, it sounds like you are trying to alias your results? If that's the case, you just need to include the name of your alias following the ufn_concat() function call:

    SELECT ufn_concat(lastname,firstname) ufn_concat, 
    FROM   table1

    You can also use the 'AS' keyword to do this as well:

    SELECT ufn_concat(lastname,firstname) AS ufn_concat, 
    FROM   table1

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, March 1, 2020 7:05 PM