not sure about mysql, but with mssql it's pretty easy... just do something like this... select id, lower('%{SQL-User-Name}'), ... or select id, upper(%{SQL-User-Name}'), ... you will find something that works if you look hard enough... ----- Original Message ----- From: "Alan DeKok" <aland@deployingradius.com> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Monday, August 07, 2006 10:14 AM Subject: Re: sql.conf fvt3 <fvt3@yahoo.com> wrote:
How do you convert the SQL-User-Name sent to upper case? I have my mac address store in upper case but the client is sending its mac address in lower case.
You can't really. Why not do a case-insensitive match in SQL? Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html