Omnis Studio v10.1 Basic Web Dev

[Martin Obongita]

 Dear All,
I have a department sql table with columns “id” and“name”
In the “departments” table class I have a method to checkfor duplicate “name” column.

I therefore pass a parameter of the old name and the newname to check for an existing department name.

Begin statement

Sta:SELECTname FROM departments

Sta:WHERE name= @[pDepartmentName] AND name <> @[pDepartmentNameOld]

End statement

When I execute the method, the flag is set to kTrue andyet there is no matching record found.

I have run this statement in the sql query builder in thedatabase and no record is found.
Where am I missing something?
Best regards,Martin Obongita.