UFN_SALESORDER_GETLABEL

create function dbo.UFN_SALESORDER_GETLABEL
(
    @ID uniqueidentifier
)
returns nvarchar(100)
as
begin
    if @ID is null
        return ''
--todo put together a string of other fields that together form a compound key, which would be more useful for display

    return coalesce(
    (
        select SALESORDER.ID
        from dbo.SALESORDER
        where SALESORDER.ID=@ID
    ),
    '')
end