query for finding a string
Posted on 2007-08-05
When I need to qrite a query for which the value in the table is characters, I have to put them in quotes. In my situation because of a poor database design, there is field, called "country of education' and the has values like france - xxx university, USA-sraucse Uni. BAsically the field contains country and the name of university as well.
Now I need to search for people who have not studied from USA e.g. but I cannot say
........ WHERE Countrt_of_Education <> 'USA' because there are very few USA only. So I need to say <>'Any thing which contains USA'
Can anyone please guide me on how to do that?
Thanks and Regards