SQL Query referencing Handy Status macro

Denver Thomas_i9m9tz

I have a column in a table filled with Handy Statuses that are "Rev_0", "Rev_1", "Rev_2", "Rev_3".

I'm trying to use the Table Transform macro to filter this table down to certain Rev's, like so:

SELECT * FROM T* WHERE 'Rev_#' = "Rev_0";
(Table Transform's SQL Query section says to reference columns using single quotes.)

 

This is everything I've tried so far:

SELECT * FROM T* WHERE 'Rev_#' = "Rev_0";

SELECT * FROM T* WHERE 'Rev_#' = 'Rev_0';

SELECT * FROM T* WHERE 'Rev_#' = Rev_0;

 

SELECT * FROM T* WHERE 'Rev_#' = "REV_0";

SELECT * FROM T* WHERE 'Rev_#' = 'REV_0';

SELECT * FROM T* WHERE 'Rev_#' = REV_0;

 

SELECT * FROM T* WHERE 'Rev_#' = 0;

 

. . . And much, much more, frankly.

Thank you for any and all assistance!

Denver Thomas_i9m9tz

SELECT * FROM T* WHERE ('Rev_#' = "REV_0")

This finally did the trick.