How would I go about converting a BPCHAR field in a table into a BOOL and then set all values of 1 = TRUE, and all values of 0 = FALSE.

Thanks,

Jesse