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 |
|
noobapap
Starting Member
2 Posts |
 Posted - 2012-02-03 : 17:01:53
|
| Hi FolksI 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.Thanks |
|
|
noobapap
Starting Member
2 Posts |
Posted - 2012-02-03 : 17:25:15
|
| Figured it out.I put the output of a select query into a variable and then done this...IF @result NOT LIKE '%Errors 0%' PRINT @resultELSEPRINT 'Errors Found' |
 |
|
|
|
|
|
Check string for number of errors