Select everything but the last three numbers in the field query

I have a query that select the first 14 chars from the field. The field
data is something like the following
PGLV120060215-AT001
DLLCV220060310-AR002
TPKGMV120060415-AT001
and so on...

I want to only select everything before the last three numbers such as

PGLV120060215-AT
DLLCV220060310-AR
TPKGMV120060415-AT
and so on ....
Note: the last three numbers will remain like 001,002,003, and so on
.... for each record and i dont want to select them i just want to
select everything that is before them.
I have the following query that slects only first 14 chars from the
field but it may vary to 12 or 13 or 10 or anything..

SELECT DISTINCT Left([FINDG_NO],14) AS Expr1 FROM tblTest1;

Can somone help me out with this please

Moe

.

Relevant Pages

  • Re: Replacing Chars
    ... go post to that thread and exaplin why it won't work ... > I am trying to replace chars in field without replacing all the chars. ... The query will select all the records on this ...
    (microsoft.public.access.queries)
  • Re: Replacing Chars
    ... Are you saying that you have "user numbers" embedded along with other ... > I am trying to replace chars in field without replacing all the chars. ... I need to run a query that promps for a user ...
    (microsoft.public.access.queries)
  • Re: Query grabs a set of chars from a field making a new field
    ... You need to set up a query with the two tables related to each other by the ... You don't need to set the fields as key fields. ... I want to grab the set of chars 1 thru 18 and make them the field ...
    (microsoft.public.access.queries)
  • Re: Query to delete extra spaces after input
    ... Ok, create a new query. ... On the icon bar click on the icon that looks like ... "julialatte" wrote: ... code that pulls the 10 chars that populate this field from a ...
    (microsoft.public.access.queries)
  • Query to use like values from other table
    ... any separator in between but all codes are of 03 chars). ... art1art2 Item 1 ... The ways I know is either use union query ... If I save all my required searching codes in a table, ...
    (microsoft.public.sqlserver.programming)