I use to use characters strings as my primary keys, but now I would like to use integer keys. With characters strings as my PKs, I was able to set up a parameterized view that would let me select either one record or all records from a table. If I wanted one record, I would set my view paramter like this:

lcJob_ID = "00001"

before I required the view. If I wanted all records, I would set the paramter like this:

lcJob_ID = SPACE(0)

Can I do the same thing if I use integer PKs?

BTW, the US Women's soccer team rocks!