var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have a DB2 SQL statement as below;
WHERE Acct_Name LIKE :ws-Acct-Name
The above statement working fine with SPUFI but not returning any matching
rows in my application program. ws-Acct-Name has a value of
'NATASHA%' in both cases.
Do I have to make any changes to the SQL while I use the LIKE operator in the application program ....?
Thanks - N.
What is a data type of ws-Acct-Name?
If it's fixed length string longer than 8, could you think that was interprited as LIKE 'NATASHA% '
(leading characters are 'NATASHA' and trailing character(s) are ' ')?
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors