RE: Constructing Sql to position phone number that breakup in are acode, prefix, suffix and extension

Hi Lim,
 

Your sql statement will only result in the phone number entered.  The
subfile display requires listing phone numbers starting from the
InputNbr. 

 
Then try the following: (But be aware, I'm not sure about the performance)
 
Select   AreaCode, Prefix, Suffix, Extenstion
   From  TelefoneFile
   Where         AreaCode  >= Substr(:InputNbr,  1, 3)
         or      AreaCode   = Substr(:InputNbr,  1, 3) 
             and Prefix    >= Substr(:InputNbr,  4, 3)
         or      AreaCode   = Substr(:InputNbr,  1, 3) 
             and Prefix     = Substr(:InputNbr,  4, 3) 
             and Suffix    >= Substr(:InputNbr,  7, 4)
         or      AreaCode   = Substr(:InputNbr,  1, 3) 
             and Prefix     = Substr(:InputNbr,  4, 3) 
             and Suffix     = Substr(:InputNbr,  7, 4)
             And Extention >= Substr(:InputNbr, 10, 3)

 

 

Mit freundlichen Grüßen

 

i.A. Birgitta Hauser

 

LUNZER + PARTNER GMBH

Consulting | Software | Service

Carl-Zeiss-Straße 1

63755 Alzenau

 

Tel:         + 49 6023 951-255

Fax:        + 49 6023 951-111

Internet.  www.lp-gmbh.com <http://www.lp-gmbh.com/> 

              www.rpg-schulung.de <http://www.rpg-schulung.de> 

 

--------------------------------------------------------

Handelsregister: Aschaffenburg HRB 4720

Gerichtsstand und Erfüllungsort Alzenau

Ust-IdNr.: DE132093146

Geschäftsführer: Rudolf Gerbert

---------------------------------------------------------