Hi All   In SAS/ACCESS connect to Snowflake interface  the function REGEXP_REPLACE is searching for exact pattern that we pass in the list of values to filter from DB. Whereas SAS/ACCESS connect to Greenplum interface the same function REGEXP_REPLACE is searching for all pattern matches that we pass in the list of values to filter from DB.    COLUMN_NAME:     DD MA COASTAL AREA COASTAL AREA GIS DD GIS MET GIS.MET GIS/ROLLOUT GIS/DD   Condition: ex: where REGEXP_REPLACE(UPPER(COLUMN_NAME),'\s+$','') in ('COASTAL AREA','DD','MET','ROLLOUT')   Greenplum Output: DD MA COASTAL AREA COASTAL AREA GIS DD GIS MET GIS.MET GIS/ROLLOUT GIS/DD   Snowflake Output: COASTAL AREA   How would i get exact above Greenplum result in snowflake ( without LIBNAME statement and Using explicit pass through facility only ). ... View more