Skip to Content
Former Member
Nov 30, 2009 at 08:56 AM

Variable selection



I have the following statements in my qry to select records from Ohem table.

/* SELECT FROM [dbo].[Ohem] T01 */

declare @name as char(20) /*WHERE */

set @name = /* T01.firstname */ '[%1]'

But I get all the records in de selection, is it possible to make an extra selection, for

exemple, only those reocrds where sex = 'M'. In other words, can I expand the 'where' clause.

Thanks, eddy

Edited by: Eddy Theunis on Nov 30, 2009 9:57 AM