Select query 1

[PappaG]

Hi All

Can anyone help i am looking for a query that will select anything from the left of the @ sign please see below examples

example 1 VQ_Booking@NIVR
example 2 45332@Newcastle

I require only

exapmle 1 VQ_Booking
example 2 45332@Newcastle

 

[PHV]

Have a look at the Left and InStr functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Golom]

Try

Left([fldname], Instr(1,[FldName],"@")-1)

 

[PappaG]

Thanks Golum

Works a treat how the heck you guys come up with these baffles me but thanks all the same