I know this is bad design, but there's no way I can get it changed.....
I need to count the rows of a table that have "**" within a field. Of
course I realize that its counting as a wild card. How can I get around
this?
In Access, I've successfully used stuff like Like "*[*]*" And Not Like
"*[*][*]*"...but I have no idea how I'm going to do this in sql 6.5

Patrick Conahan


MS Sql Server LazyDBA home page