[PERDITION-USERS] Domain delimiter question

Hi, I'm using perdition as a POP3 and IMAP proxy for about 1 year. At this time I have 2 perdition servers as standalone proxies with one mailserver backend behind them. There was never a problem with this type of setup. Now I'm planing to split my mailserver backend in 2 ore more different servers. So I'm able to scaling out my server environment more flexible in the future. I'm trying to use mysql popmap for all of my hosted domains (about 6.000). My idea was to store all domains and the information of their backendservers in a mysql database. My database scheme looks like this: Domain Server Port domain1.com 192.168.1.10 NULL domain2.com 192.168.1.11 NULL domain3.com 192.168.1.10 NULL domain4.com 192.168.1.11 NULL ... and so on. With this setup I'm able to define for each domain a different backend server, which will be very practical for future scaling etc. The only problem I have is: All my users are using different logintypes. Some of them are using for example "user(a)domain1.com" as username. Other users are using "user%domain1.com" as username. So I have two different domain delimiters to search for (@ and %). To change this on the user site is not possible. There are about 25.000 users. I must find a way to filter the domain from the full username based on the domain delimiter. My current query key is: query_key \\d My map library options are: map_library_opt "mysqlserver:3306:dbname:dbtable:dbuser:dbpass:server:domain:port" Some of you have any idea how I can solve my problem? Is there a way to use 2 domain delimiters? Many thanks and regards Urban P.s. sorry for my poor english.