Cetin,

No I have not set the view properties. And I am doing all this in code, so I am not using a veiw designer.

I have two fields to change. The status field comes across as a two digit number, 23, 25, 30, 48... as a character. But in my select, I had to select for status < 85 (not a character). And the date comes across in 20050130 character format that I want to convert to a 01/30/05 character. (Same number of characters). My view displays in a grid, but I thinkit is not updatable for some reason.

Ron