Search for ZIP code with leading zero

If you are using gviz, use the LIKE operator

  • like - A text search that supports two wildcards: %, which matches zero or more characters of any kind, and _ (underscore), which matches any one character. This is similar to the SQL LIKE operator. Example: where name like fre% matches 'fre', 'fred', and 'freddy'. (Ensure you use the UriEncode block to properly encode the %)

or use starts with
SELECT * WHERE B STARTS WITH ''01'