SQL query with & in where clause
How do we handle a SQL query with & in the where clause? The table is present in external database
For example
Select * from TABLENAME where NAME='Tom & Jerry';
This doesn't respond back with results even though there are rows in the TABLE with NAME as 'Tom & Jerry'.
Facing this issue with RD generated queries as well.
Accepted Solution
Updated: 9 Jan 2025 9:30 EST
Pegasystems Inc.
GB
@DLLAVANYA To handle a SQL query with a where clause for an external database you can use Connect SQL and refer to that SQL in RDB methods. This approach allows you to specify the target table and manage the query execution more precisely. Additionally ensure that the object names in your SQL query are correctly cased as SQL keyword case does not matter but the object names should match the case stored in the RDBMS dictionary. If you need to use mixed or lower case names pass them in double quotes to make them understandable to the DB Engine.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
How can we fetch data from different tables apart from using RD