Sample data from table in question(f_tablename)

clnt_access <---column varchar(3), NOT NULL

No

No

No

No

Yes

Yes

Yes

Yes

No

No

Yes

Yes

clnt_access <--column bit, not null

0

1

0

0

I am trying to convert the yes/no in the first table...