CREATE TRIGGER ATest

ON character.dbo.user_character

FOR INSERT, UPDATE

AS

declare @tmp varchar(40)

select @tmp=I.character_name fron inserted I

1f patindex('xG%',@tmp)>e

begin

ROLLBACK TRANSACTION

END

1f patindex('XDEV%',@tmp)>0

begin

ROLLBACK TRANSACTION

ENDS

1f patindex('%DEKARON%',@tmp)>e

begin

ROLLBACK TRANSACTION

END

if patindex('%OPR%',@tmp)>e

begin

ROLLBACK TRANSACTION

END