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

thanks working

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