Subject SQL Statement From Robin Rickard <rob@no.spam.calculation.com.au> Date Tue, 17 Jul 2018 22:53:59 -0400 Newsgroups dbase.getting-started Hi All what is the best way of getting a SQL statement to only show records that are contained in a field. example: i have a field for staffareas. in this there might be ADH or ABD etc. A is an area that they work in, but they may also work in E, F etc Using the "$" in non sql i used to go ... for mstaff $ staffareas "Select * from staff.dbf where mstaff $ staffarea"  does not work. Can somebody please guide me right direction. Regards Rob