Problem with extracting variable data from a string

[Topcerv]

I have a table that lists items in a fully qualified domain name and I need to list the hostnames of the systems in a seperate field without the FQDN. For example:

FIELD: FHOSTNAME
DATA: dcsdc1.dcsecurity.com

I will run an update query with the below string to the destination SHostname and I get the relfected output.

Left([FHostname],Len([FHostname])-(InStr([FHostname],'.')))



FIELD: SHOSTNAME
DATA: dcsdc1.dcsecu


What I am trying to get pulled is the DCSDC1 which is the short hostname.

Any one see my error?
Thanks

[June7]

Try

Left([FHostname],InStr([FHostname],'.')-1)

[Topcerv]

Works Great! Thanks.