globalstrata
MIS
Ok. I thought I could pick this up and do some simple queries but I guess it takes a genius - so lets ask the experts …
I am trying to do a query that selects or records that a field do not have a value equal to '%WORKSTATIONS' in other words anything that is NULL or anything that does not end in the WORSTATIONS word. Well, I am creating the following
select *
From table
where table.field not like '%WORKSTATIONS'
But the query seems to be giving me every like '%WORKSTATIONS'
I think that the reason may be because the content is as follows:
1 "one/", "one", "one/two/department WORKSTAIONS"
2 "one/", "one"
3
How can I search gives me record 2 and 3 instead of 1?
Thanks for your help,
Gladys Rodriguez
GlobalStrata Solutions
I am trying to do a query that selects or records that a field do not have a value equal to '%WORKSTATIONS' in other words anything that is NULL or anything that does not end in the WORSTATIONS word. Well, I am creating the following
select *
From table
where table.field not like '%WORKSTATIONS'
But the query seems to be giving me every like '%WORKSTATIONS'
I think that the reason may be because the content is as follows:
1 "one/", "one", "one/two/department WORKSTAIONS"
2 "one/", "one"
3
How can I search gives me record 2 and 3 instead of 1?
Thanks for your help,
Gladys Rodriguez
GlobalStrata Solutions