I'm trying to use a variable in the SELECT statement in the following CREATE SQL VIEW command. I've tried it various different ways ("&p_claimno", "p_claimno", and p_claimno) but each time I get an ODBC error. Any ideas? (I can't create the view using the view designer, the entire command creates a view using left outer joins that I couldn't get working with the view designer).

create sql view add_update2 remote connection upsize share as SELECTfield names FROM Claimant_record
WHERE Claim_Number > &p_claimno;