criteria not working properly?

Question

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Fraggle-805517 SSCrazy Eights Points: 8907 More actions · Answer 1

Try putting the statement in the WHERE part.

where CustID not like '%-%'

kellyrmartin-805750 SSChasing Mays Points: 645 More actions · Answer 2

SSChasing Mays

Points: 645

September 3, 2008 at 8:47 pm

I tried that and it doesent work either

Fraggle-805517 SSCrazy Eights Points: 8907 More actions · Answer 3

What is the data type of the column?

Just to clarify, your data looks like this in the ID column.

1234567

234-567

kellyrmartin-805750 SSChasing Mays Points: 645 More actions · Answer 4

The ID is char(12)... The two examples you gave are what you could expect in this database.

Fraggle-805517 SSCrazy Eights Points: 8907 More actions · Answer 5

try running a query directly against the table itself with just the where clause from above and see if it returns the desired results.

select top 20 percent CustomerID from Table where CustomerID not like '%-%'

That should tell us if it is something with the query or the view.