Visual Basic functions within a Trigger

[Jayson]

I'm currently using SQL Server 2000, i need to create a trigger, which will read fields on the inserted record, and somehow parse that field using Visual Basic built in functions like "Instr()" and "Mid()", do some calculations with it - like converting it to 'double' then update/insert the resulting value onto another designated field on the record.

Is this possible? If not, what else can i use to accomplish this? Stored procedure maybe?

Thanks for any suggestion! really appreciate any help

 

[fluteplr]

Look at user defined functions. You should be able to write one that will do what you want using a combination of the t-sql functions substring, charindex and patindex

 

[Jayson]

Thanks for the quick response! I'll give it a try!