Impact Analysis - Like & Equal in command
Posted: Thu Oct 16, 2008 3:33 pm
I am not able to get desired results using the following the command:
SELECT NAME FMT '50L', CATEGORY FMT '60L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL 'UPCASE(@RECORD)' = '$Table')
$Table is parameter passed in shell script
But when I use LIKE instead of '=', I am getting results.
SELECT NAME FMT '50L', CATEGORY FMT '60L' FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL 'UPCASE(@RECORD)' = '$Table')
$Table is parameter passed in shell script
But when I use LIKE instead of '=', I am getting results.
I want to search for exact name but not for strings. Is there a way using above command?i.e EVAL 'UPCASE(@RECORD)' = '$Table' is not working but EVAL 'UPCASE(@RECORD)' LIKE '%$Table%' IS WORKING