Your suggested change has been received. Thank you.

Suggest A Change

Please Note:

UDFs for Non-FPE

The following table lists the UDFs for standard encryption. These UDFs are categorized by data type:

CHAR

Data Type	Function	Action
CHAR	ing_e_chr_cl420	encrypt
CHAR	ing_e_chr_nm420	encrypt
CHAR	ing_d_chr_cl420	decrypt
CHAR	ing_d_chr_nm420	decrypt

NCHAR

Data Type	Function	Action
NCHAR	ing_e_ncr_cl420	encrypt
NCHAR	ing_e_ncr_nm420	encrypt
NCHAR	ing_d_ncr_cl420	decrypt
NCHAR	ing_d_ncr_nm420	decrypt

DECIMAL

Data Type	Function	Action
DECIMAL	ing_e_dec_cl420	encrypt
DECIMAL	ing_e_dec_nm420	encrypt
DECIMAL	ing_d_dec_cl420	decrypt
DECIMAL	ing_d_dec_nm420	decrypt

SMALLDATETIME

Data Type	Function	Action
SMALLDATETIME	ing_e_sdt_cl420	encrypt
SMALLDATETIME	ing_e_sdt_nm420	encrypt
SMALLDATETIME	ing_d_sdt_cl420	decrypt
SMALLDATETIME	ing_d_sdt_nm420	decrypt

DATETIME

Data Type	Function	Action
DATETIME	ing_e_dtm_cl420	encrypt
DATETIME	ing_e_dtm_nm420	encrypt
DATETIME	ing_d_dtm_cl420	decrypt
DATETIME	ing_d_dtm_nm420	decrypt

INT

Data Type	Function	Action
INT	ing_e_int_cl420	encrypt
INT	ing_e_int_nm420	encrypt
INT	ing_d_int_cl420	decrypt
INT	ing_d_int_nm420	decrypt

BIGINT

Data Type	Function	Action
BIGINT	ing_e_bin_cl420	encrypt
BIGINT	ing_e_bin_nm420	encrypt
BIGINT	ing_d_bin_cl420	decrypt
BIGINT	ing_d_bin_nm420	decrypt

MONEY

Data Type	Function	Action
MONEY	ing_e_mny_cl420	encrypt
MONEY	ing_e_mny_nm420	encrypt
MONEY	ing_d_mny_cl420	decrypt
MONEY	ing_d_mny_nm420	decrypt

SMALLMONEY

Data Type	Function	Action
SMALLMONEY	ing_e_smo_cl420	encrypt
SMALLMONEY	ing_e_smo_nm420	encrypt
SMALLMONEY	ing_d_smo_cl420	decrypt
SMALLMONEY	ing_d_smo_nm420	decrypt

NVARCHAR

Data Type	Function	Action
NVARCHAR	ing_e_nvc_nm420	encrypt
NVARCHAR	ing_e_nvc_cl420	encrypt
NVARCHAR	ing_d_nvc_nm420	decrypt
NVARCHAR	ing_d_nvc_cl420	decrypt

NVARCHAR (MAX)

Data Type	Function	Action
NVARCHAR (MAX)	ing_e_nvrcl_cl420	encrypt
NVARCHAR (MAX)	ing_e_nvrcl_nm420	encrypt
NVARCHAR (MAX)	ing_d_nvrcl_cl420	decrypt
NVARCHAR (MAX)	ing_d_nvrcl_nm420	decrypt

VARBINARY (MAX)

Data Type	Function	Action
VARBINARY (MAX)	ing_e_vrbl_cl420	encrypt
VARBINARY (MAX)	ing_e_vrbl_nm420	encrypt
VARBINARY (MAX)	ing_d_vrbl_cl420	decrypt
VARBINARY (MAX)	ing_d_vrbl_nm420	decrypt

VARCHAR

Data Type	Function	Action
VARCHAR	ing_e_vrc_nm420	encrypt
VARCHAR	ing_e_vrc_cl420	encrypt
VARCHAR	ing_d_vrc_nm420	decrypt
VARCHAR	ing_d_vrc_cl420	decrypt

VARCHAR (MAX)

Data Type	Function	Action
VARCHAR (MAX)	ing_e_vrcl_cl420	encrypt
VARCHAR (MAX)	ing_e_vrcl_nm420	encrypt
VARCHAR (MAX)	ing_d_vrcl_cl420	decrypt
VARCHAR (MAX)	ing_d_vrcl_nm420	decrypt

XML

Data Type	Function	Action
XML	ing_e_xml_cl420	encrypt
XML	ing_e_xml_nm420	encrypt
XML	ing_d_xml_cl420	decrypt
XML	ing_d_xml_nm420	decrypt

Next Topic

How to call direct UDFs for non-FPE