SQL query for not equal Stereotype

[dgoetz]

I want to query for all attributes with a stereotype not equal to "abcd". I am using EA 13.5.

This query will find all attributes with stereotype "abcd":
  select *
  from t_attribute a
  where a.Stereotype like 'abcd'

The contrary search is obvious:
  select *
  from t_attribute a
  where a.Stereotype not like 'abcd'

But although there are attributes with an empty stereotype in the EA-project, the query returns no result.

Regards
Dieter

[Paolo F Cantoni]

I want to query for all attributes with a stereotype not equal to "abcd". I am using EA 13.5.

This query will find all attributes with stereotype "abcd":
  select *
  from t_attribute a
  where a.Stereotype like 'abcd'

The contrary search is obvious:
  select *
  from t_attribute a
  where a.Stereotype not like 'abcd'

But although there are attributes with an empty stereotype in the EA-project, the query returns no result.

Regards
Dieter

Dieter,
The contrary search is NOT obvious:
  select *
  from t_attribute a
  where a.Stereotype not like 'abcd' or a.Stereotype is Null

As a Data Architect, I HATE Nulls...

Paolo

[Uffe]

What's that you say? Null not the same as empty?

Sir, I am shocked. Shocked!

 

[qwerty]

Just try adding 

Code: [Select]

or a.Stereotype = ''
q.

[Geert Bellekens]

Just try adding 

Code: [Select]

or a.Stereotype = ''
q.

That's not the same thing and won't help in case of null

For large databases/complex queries it is often better to avoid "or" statements in the where clause because of performance issues.
That can be avoided by using something like

isnull(a.Stereotype,'') <> 'someStereotype' -- works for SQL Server

or

Coalesce(a.Stereotype,'') --might work for other databases

Each database has a bit it's own operator to replace null values with something else.

Geert

[dgoetz]

Thanks for the help. Null is working.