Filter Records in SQL Confluence based on VARCHAR or TEXT data

[Dhiraj Kr_ Gupta]

I have a table Transformer which contains  columns NAME, Owner and ID

Name Owner ID

Jack   Yes     125

John  Yes     162

Gray   No      729

Shui    No      625

Dhiraj Yes      728

When I am retrieve the records based on WHERE Owner = 'Yes' or 'No', it does not returning anything, or any thing based on Text or Varchar

But it is returning when I am retrieving based on ID., Then it is working fine

Please Help me !!!!!

[Stiltsoft support · Accepted solution]

Hi @Dhiraj Kr_ Gupta ,

The issue is in your WHERE clause, please try

WHERE 'Owner' LIKE "Yes"

[Dhiraj Kr_ Gupta]

Thank You Very Much

[Manne Kjærby - ProProces · Accepted solution]

Hi Dhiraj.

I believe it should look like this:

'Owner' = "Yes"

[Dhiraj Kr_ Gupta]

Thankyou Very Much