UFN_BBIS_GETCOUNTRYSTRINGFROMSTATE
Return
| Return Type |
|---|
| nvarchar(100) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @STATE | nvarchar(100) | IN |
Definition
Copy
create function dbo.UFN_BBIS_GETCOUNTRYSTRINGFROMSTATE(@STATE nvarchar(100))
returns nvarchar(100)
with execute as caller
as begin
return (select top 1 COUNTRY.DESCRIPTION
from dbo.STATE
inner join dbo.COUNTRY on STATE.COUNTRYID = COUNTRY.ID
where STATE.ABBREVIATION = @STATE)
end