Partial email select and show

[George Michael]

Hello


Anyone know how to select the first part of an email stored in a table?


For example: table: user> [e-mail]
with the query: SELECT * FROM user, will show: [e-mail]


Does anyone know how to make it show ONLY the first part? Just: username ?



Thanks in advance!

George



Edited 1 time(s). Last edit at 06/25/2006 02:46PM by George Michael.