Find substring in element notes using SQL query

[Fuglesteg]

Hello,

I am trying to create a model view listing all requirements in my model that has the word TBD in t_object.Note. TBD is part of a requirement statement. I have tried the following code with various wildcard combinations:

SELECT t_object.Alias As Alias, t_object.Name As Name, t_object.Note As notes
From t_object
Where t_object.Object_Type = 'Requirement' And t_object.Note LIKE '%TBD%'

This seems to work only when TBD are the only word in the notes. It does not return any results if TBD is part of a sentence.

Any help is appreciated.

[Uffe]

Hello,

The wildcard character differs between SQL dialects, so it depends on which DBMS you're using.
For Access databases (.EAP file), the query works with '*'.

/Uffe

[Fuglesteg]

Thank you uffe,
Problem solved

[Geert Bellekens]

In the future best use the macro #WC# as this works on any type of repository.

Geert

[Uffe]

In the future best use the macro #WC# as this works on any type of repository.

Does that work in free-form SQL queries entered manually?

[Geert Bellekens]

In the future best use the macro #WC# as this works on any type of repository.

Does that work in free-form SQL queries entered manually?

No, only in actual SQL Search queries, not in the scratch pad (and probably not when using the API)

Geert