Translation Function Spec

<TranslationFunctionSpec
	xmlns="bb_appfx_translationfunction"
	xmlns:common="bb_appfx_commontypes"
	ID="8021b7b7-c710-4418-888f-aed036730963"
	Name="USR_UFN_TRANSLATIONFUNCTION_EXAMPLE"
	Description="Translation function for Example search list"
	Author="Technical Training"
	RecordType="Example (custom)"
	>

	<SQLTranslationFunction FNName="USR_UFN_TRANSLATIONFUNCTION_EXAMPLE">
		<common:CreateFunctionSQL>
			<![CDATA[
create function dbo.USR_UFN_TRANSLATIONFUNCTION_EXAMPLE
(
	@ID uniqueidentifier
) 
returns nvarchar(10) 
as
begin
	declare @s nvarchar(10);
	select @s = SHORTNAME from dbo.USR_EXAMPLE where ID = @ID;
	return @s;
end	
			] ]>
		</common:CreateFunctionSQL>
	</SQLTranslationFunction>

</TranslationFunctionSpec>