Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: M. Akram Bhatti
  Where is M. Akram Bhatti?
 Riyadh
 Saudi Arabia
 M. Akram Bhatti
 To: khubaib khalid
  Where is khubaib khalid?
 HaroonAbad
 Pakistan
 khubaib khalid
 Tags
Subject: RE: slect record
Thread ID: 249039 Message ID: 249040 # Views: 1 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Sunday, December 27, 2009 12:26:57 PM         
   


> i have filed name admitted, replace value with 1 and 2
>
> i want to select records as. if admitted =1 admitted value should be Yes,
> If admitted =2 admitted value should be NO;
>
> select admitted as Yes, admitted as no from table hixi

Select Icase(admitted = 1, "Yes", admitted = 2, "No", "") AS Adm_Status From hixi


Regards,
akram

ENTIRE THREAD

slect record Posted by khubaib khalid @ 12/27/2009 12:19:40 PM
RE: slect record Posted by M. Akram Bhatti @ 12/27/2009 12:26:57 PM
RE: slect record Posted by khubaib khalid @ 12/27/2009 12:34:52 PM
RE: slect record Posted by M. Akram Bhatti @ 12/27/2009 12:48:36 PM