How can I insert a function into a query? I have a select query like the below and would like tio insert the function nameed below in the query:
I have a simple select query that I would like to insert a function in the middle . Name of the function "fnryNbr". I would like it in the place of the second line from below:
SELECT Staff.FirstName + ' ' + Staff.LastName AS Staff_Name,
[Case].EndDate, CaseStatus.Name AS [case Status],
Appointment.DateTime, Appointment.Id AS ApptID, Appointment.Status AS ...
would I need to link the function to the tables. I have never added a function to a query. Please help :)