UFN_MEMBERSHIPPROMOCODE_CODEEXISTS
Checks the MEMBERSHIPPROMOCODE table for the given code
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CODETOTEST | nvarchar(50) | IN |
Definition
Copy
create function dbo.UFN_MEMBERSHIPPROMOCODE_CODEEXISTS
(
@CODETOTEST nvarchar(50)
)
returns bit
with execute as caller
as begin
if exists (select 1 from dbo.MEMBERSHIPPROMOCODE where PROMOTIONALCODE = @CODETOTEST)
return 1
else
return 0
return 0
end