Home Forums Article Discussions Article Discussions by Author Discuss content posted by kgayda Find Table Usage RE: Find Table Usage
hha0
Valued Member
Points: 58
More actions
October 9, 2007 at 12:50 am
#740251
This script didn't work if a tab was used before the tablename. I modified the like clause like this and it seemed to pick them up
ON c.Text LIKE '%[ ,=' + CHAR(9) + ']' + t.TableName + '[ .,' + CHAR(9) + ']%'