Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-26 : 11:07:07
|
| Xau Xi writes "I have a table in DB2 that contains the following fields: JobCode char(10),JobCone char (4), GradeLevel char(2), GradeQual char(4).I want to write a trigger that will automatically break the JobCode char(10) field into 3 piece. The first 4 letters will be inserted into JobCone, the next 2 will be inserted into GradeLevel, and the last 4 will be inserted into GradeQual.Would you please show me how to break a field into pieces and insert these pieces into different fields in TRIGGER. Thank you very much." |
|
|
|
|
|
DB2 trigger