Capstone project level 2 q. what is the correct query to retrieve an option_id from spread of type S

Academy Support
1

capstone project level 2 q. what is the correct query to retrieve an option_id from spread of type S

select from spread where option_id = sym$,FB20200720C240
select from spread where option_id = sym,FB20200720C240
select from spread where option_id = FB20200720C240 select from spread where option_id = (FB20200720C240)
select from spread where option_id = ("FB20200720C240")

2

General form:

select from tab where columnA=`someSymbol

Or if the symbol contains characters which mean ` cannot be used then wrap in `$""

select from tab where columnA=`$"someSymbol-with-special-characters"