Assuming the clients are connecting directly to the database, this should do:
SELECT client_net_address
FROM sys.dm_exec_connections
WHERE session_id = @@spid
If this is a web application or runs on any sort of application server, you'll have to gather the address from the client side of the application.