Hello freeradius users, I have searched the freeradius unlang documentation, but couldn’t find a way to make the following piece of unlang code more effective: if ("%{sql:SELECT username FROM radcheck WHERE username LIKE '%{string:&ADSL-Agent-Remote-Id}@%%' LIMIT 1}" != "") { update request { User-Name := "%{sql:SELECT username FROM radcheck WHERE username LIKE '%{string:&ADSL-Agent-Remote-Id}@%%' LIMIT 1}" } } Basically what I’m trying to do is to check if the query in question returns the username and to use this username in a self created variable later on. Something like this: username-var = SELECT query; if (username-var != “”) { update-request { User-Name := username-var } } How would I achieve this? What is the syntax that can be used here? Thanks! Met vriendelijke groet \ With kind regards, Marijn van Gool NOC Network Engineer noc@comsave.com <mailto:noc@comave.com> +31 88 999 5555 marijn.vangool@comsave.com <mailto:marijn.vangool@comsave.com> www.comsave.nl <http://www.comsave.nl/>