Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How can i retrieve city while my i have one field address
length 60 but i don't know what where is city in this field ?

Answers were Sorted based on User's Feedback



How can i retrieve city while my i have one field address length 60 but i don't know what wher..

Answer / tuhina

select cityfldname from DBF where cityfld like '%cityname%'

Is This Answer Correct ?    2 Yes 1 No

How can i retrieve city while my i have one field address length 60 but i don't know what wher..

Answer / chandrasekhar gangireddy

by using DSPPFM on file, type "city" on search fields then press enter u will get the city

Is This Answer Correct ?    1 Yes 1 No

How can i retrieve city while my i have one field address length 60 but i don't know what wher..

Answer / vivek dwivedi

Using Var = %Scan('City' :1: length o the base string)

Is This Answer Correct ?    0 Yes 0 No

How can i retrieve city while my i have one field address length 60 but i don't know what wher..

Answer / paramesh

select cityfldname from DBF where cityfld = '%cityname%'

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More DB400 Interview Questions

There are six records in a file and we are going to update that records and used commit operation when it complete the update but suppose when it updating the third record,a error occured and operation failed.Is previously two records will be update or whole operation will be rollback? Please confirm it.

2 Answers  


How to read a PF in reverse(from last rec to first) using CL?

3 Answers   HCL,


can we concate fileds in physical file? If yes how can we do?

5 Answers   Patni,


pls anyone explain about compile time array,pre run time array run time array

4 Answers  


How to know the particular record in pf with out reading?

0 Answers  


What is the purpose of the chain and setll and setgt?

0 Answers  


I had created one physical file tell me command to enter data in to?

1 Answers  


what is multiple member pf

1 Answers   Active Brains,


Is Constent can be define as a key field?

3 Answers  


what is use of self join and which cases you will use this join

1 Answers   TCS,


YOU CAN DELETE THE RECORD SPACE PERMENANTLY IN PHYSICALFILE THROUGH CL?

4 Answers  


What is open data path?

0 Answers  


Categories