Hi
I 've a mdb which has one table and the structure would be
tab1
----
no integer
ch char(1) may hold either 'a' or 'b' OR 'C'
------------------
IF I SELECT THE ABOVE TABLE Tab1 thru query in Data environemnt of
VB6.0 i NEED THE RESULT TO DISPLAY ALL THE RECORDS(ABBRIVATION) LIKE
THE
NO CH
-------------
1 APPLE 'FOR VALUE 'A'
2 BOY 'FOR VALUE 'B'
3 CAT 'FOR VALUE 'C'
HOW TO DO THIS IN ACCESS (IS THERE IS ANY 'SELECT CASE ')
With Regards
Raghuraman