Parsing problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

hi,

I have this query that I am using to parse this data 12345-1 into 12356 and
1

SELECT INVS, Right$([INVS],Len([INVS])-InStr(1,[INVS],'-')-1) AS WOSUF,
Left$([INVS],InStr(1,[INVS],"-")-1) AS WOPRE
FROM Temp;

I get the 12345 but not the "1"

There is something wrong with the formula, but I cannot figure it out.

Regards,

Bre-x




.

Relevant Pages

  • Re: Need help creating temporary table from filter
    ... more sense than either 1) repeatedly creating/deleting a temp table, ... need to do that when you substitute a SELECT query? ... the same way as you were using tblTemp*. ... I'm currently reading up on For Each/Next loops to parse through the ...
    (microsoft.public.access.formscoding)
  • Re: Sybase error -5702 and -1
    ... It seems that insert query on temp tables by procedure is causing ... Prev by Date: ...
    (comp.databases.sybase)
  • Re: help
    ... If order by doesn't work then how can i frame my temp table so that i ... can work on Jen's query ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • generate a temporary table
    ... Can a query be created that generates a temporary ... a report uses that temp table for input? ... Prev by Date: ...
    (microsoft.public.access.queries)
  • RE: Parsing problem
    ... > FROM Temp; ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)