Dwain,,,,

My sexID will never contain embedded quotes...because with this table

*Bio

bioIB

fname

mname

lname

sexID

statusID

*sex

sexID

sex(male or female only)

*status

statusID

status(single,married or divorced only)

sexID and statusID from bioID belongs to different table...

so my View table would be

*MyViewTable

(Contains all in table bio, sex and status)..

i can just pass sexID and statusID to my SP...