HI GUYS,
SORRY FOR THE TROUBLE ITS SIMILAR TO MY PREVIOUS QUESTIONS BUT I GOT STRUCK IN THE MIDDLE AND I AM GETTING PROBLEM WHILE PLACING THE APPROPRIATE QUOTES FOR THE 'BOTH' CONDITION

-SET ®IONTYPE1 = '''' | ®IONTYPE | '''';
-SET &WHERE_REGIONTYPE = IF ®IONTYPE NE 'ALL' THEN ' AND REGDET.REGION_TYPE = ' | ®IONTYPE1
ELSE IF ®IONTYPE EQ 'BOTH' THEN ' AND REGDET.REGION_TYPE IN '
'''| ''''EAST'''',''''NORTH WEST'''' |''' ELSE' ';

WHERE REGDET.REGION_TYPE IS MY FIELDNAME AND EAST AND 'NORTH WEST' ARE MY FIELD OPTIONS

THANKS AND REGARDS
MADDY

Is this what your trying to do?

-SET �IONTYPE1 = '''' | �IONTYPE | '''';
-SET &WHERE_REGIONTYPE = IF �IONTYPE NE 'ALL' THEN ' AND REGDET.REGION_TYPE = ' | �IONTYPE1
ELSE IF �IONTYPE EQ 'BOTH' THEN ' AND REGDET.REGION_TYPE IN (''EAST'',''NORTH WEST'', ''ELSE'')';

When trying to put single quotes in a variable you need to put a single quote in front of each single quote.

-SET &TST1 = '''';
-TYPE var: &TST1 should be: '

-SET &TST2 = '''HI';
-TYPE var: &TST2 should be: 'HI

-SET &TST3 = '''''';
-TYPE var: &TST3 should be: ''

-SET &TST4 = '''HI''';
-TYPE var: &TST4 should be: 'HI'