Hello all I want to insert cisco AV Pairs from accounting request packet into database. Here is the accounting request packet for a single leg. Acct-Session-Id = "00000B93" Calling-Station-Id = "216" Called-Station-Id = "9833515315" Cisco-AVPair = "call-id=19421006761822000202723@202.80.61.42" h323-setup-time = "h323-setup-time=*14:42:31.708 PCTime Fri May 26 2006" h323-conf-id = "h323-conf-id=989CA2C5 EBCE11DA 81EF9672 750B1B97" h323-call-type = "h323-call-type=VoIP" Cisco-AVPair = "h323-incoming-conf-id=989CA2C5 EBCE11DA 81EF9672 750B1B97" Cisco-AVPair = "session-protocol=sipv2" h323-connect-time = "h323-connect-time=*14:42:34.904 PCTime Fri May 26 2006" Acct-Session-Time = 4 h323-disconnect-time = "h323-disconnect-time=*14:42:39.020 PCTime Fri May 26 2006" h323-disconnect-cause = "h323-disconnect-cause=10" h323-remote-address = "h323-remote-address=202.80.61.42" h323-voice-quality = "h323-voice-quality=0" Cisco-AVPair = "remote-media-address=202.80.61.42" Cisco-AVPair = "gw-rxd-cgn=ton:0,npi:0,pi:0,si:0,#:216" User-Name = "202.80.61.42" Acct-Status-Type = Stop Service-Type = Login-User NAS-IP-Address = 202.80.61.1 Acct-Delay-Time = 0 I changed the default table structure to include the extra columns. Also made changes in sql.conf to add values in the respective columns. Here is my problem. I insert h323-remote-address by adding '%{h323-remote-address}' in the insert query But I get the value as h323-remote-address=202.80.61.42 whereas I wanted only the ip address not the complete string after the '=' sign. Also I want to insert other fields like callid, remote-media-address both of which are Cisco AVPair. So how do I include them into my database coz I cant refer them direcly by their attribute name like '%{remote-media-address}. I tried that but it doesn't return any value. So how do I insert all these values. Thanks Vignesh