Posted - 02/03/2012 : 17:01:53
| Hi Folks
I hope you can help me out here. I'm working with a database where a particular table has a char(80) column called 'Details' which is used to report whether a process produced an error.
The output can look some like this.
Processing of task A complete.
Processing of task B complete.
Checks complete. Processed: 150. Errors 0.
Processing of task C complete.
Processing of task D complete.
Checks complete. Processed: 52. Errors 13.
Is it possible to do something if the column 'Details' contains Errors > 0 like set an variable to true or something?
I'm not too sure on where to start with conditional checks with a string and a wildcard so your help would be truly appreciated.