How to Remove '-' from QAA -

Can someone help me with a query that removes the '-' from
as string QAA -
ThanksDo you mean something like this:
Select Left('QAA-',3)
"Disney" <Disney@.discussions.microsoft.com> wrote in message
news:FAEFEC69-13FE-43E4-A24E-1EB170CA3445@.microsoft.com...
> Can someone help me with a query that removes the '-' from
> as string QAA -
>
> Thanks
>|||replace('QAA -', '-', '')
rtrim(replace('QAA -', '-', ''))
to get rid of any trailing spaces.
"Disney" <Disney@.discussions.microsoft.com> wrote in message
news:FAEFEC69-13FE-43E4-A24E-1EB170CA3445@.microsoft.com...
> Can someone help me with a query that removes the '-' from
> as string QAA -
>
> Thanks
>|||hi
select left('qaa-',3)
--
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"Disney" wrote:

> Can someone help me with a query that removes the '-' from
> as string QAA -
>
> Thanks
>sql