I am trying to look for a specific record using SPT but the following doesn't seem to work, it gives me all the records. I want parameter "g" to work. I am writing this statement wrong? I am trying to retrieve this from access database.

	g = '444-44-4444'
	lcSql = " Select *" ;
	      + "  FROM UDFields" ;
	      + "  where UD.SSNo = (g)" ;

	lnRes = SQLEXEC( .nCon, lcSql, "lcresults" )

Thanks
Nick Patel