How to Remove '-' from QAA -

11 Nov 2005 4:41 PM

Disney

Can someone help me with a query that removes the '-' from

as string QAA -

Thanks

11 Nov 2005 4:44 PM

MAS

Do you mean something like this:

Select Left('QAA-',3)

Show quote

"Disney" <Dis***@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
>

11 Nov 2005 4:48 PM

Raymond D'Anjou

replace('QAA -', '-', '')

rtrim(replace('QAA -', '-', ''))
to get rid of any trailing spaces.

Show quote

"Disney" <Dis***@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
>

11 Nov 2005 4:50 PM

Jose G. de Jesus Jr MCP, MCDBA

hi

select left('qaa-',3)

--
thanks,

------------------------------------
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787

Show quote

"Disney" wrote:

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