kewl

Kewl, thx swamy

ooh srry man, i got it solved,  Lynn's method works fine

or is it?

you could try somtin like this:

Members(Mem_ID,...........) Main Table

Item_Type(Type_id (S) (B), Item_Types) Lookup_Table> (S) shoes,(B) bikes

Item_Value(Item_Value_Id,Mem_ID,Type_id, IV_ID, Item_Attributes_Values)

Attributes_Values(AV_id, Type_ID, IV_Values) Lookup

>>lookup table Contains all possible Item Attributes arranged by Item...

ooh sorry, what i'm actaully saying is that i want the function to return multiple columns (Multiple output value function).

thx man

didn't work

it's dropping other rows

here's an example of my where clause

where

Patient_Current_Pregnancy_details

.Gestational_Age_weeks >=