Regular Expressions 101

Explanation

Pro

\ba Unicode word boundary

castthe literal text cast (case sensitive)

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Group 1(")?

?repeats the group contents below at most once:

"the literal " (34₁₀ / 42₈ / 22₁₆)

Group 2(zone)

zonethe literal text zone (case sensitive)

Condition(?(1)"|\s)

Uses the first branch if group 1 matched

If the condition is true, match this branch:"

"the literal " (34₁₀ / 42₈ / 22₁₆)

Otherwise, match this branch:\s

\sa Unicode whitespace character

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Detailed match information will be displayed here automatically.

25 tokens

\bcast\((")?(zone)(?(1)"|\s)

New

cast("zone" as varchar(100)) as zoneID
cast(zone as varchar(100)) as zoneID
cast(zone) as varchar(100)) as zoneID

cast("zone" as varchar(100)) as zoneID
cast(zone as varchar(100)) as zoneID
cast(zone) as varchar(100)) as zoneID