Sql Select Question

[1SorryDog]

This maybe a dummy question but here goes....

Not sure which SQL forum to post this question but...
I have a select statement for an ORACLE database similar to this:

SELECT * FROM MY_TABLE WHERE DESCRIPTION = '1234-GEORGE'

The DESCRIPTION field is defined as variable charater. It seems that the minus sign in killing the select statement. No rows returned.

However this works:

SELECT * FROM MY_TABLE WHERE DESCRIPTION LIKE '1234%'

But, I need the remaining charaters after the dash as they can be anything, for exapmle DESCRIPTION = '1234-TOMMY'

Is there any way for sql to see the minus sign as a dash or string charater instead of a minus sign???

Any suggestions would be appreciated.

One last note, the minus sign can't be eliminated as this is as example of a part number.


Thanks.


SorryDog

 

[gmmastros]

This forum is for Microsoft SQL Server. You're looking for an oracle forum forum759

You are likely to get a more timely answer in that forum.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[1SorryDog]

Thanks gmmastros. I couldn't find an ORACLE forum from the listing.

Since I don't know how to move the post, I'll post over there.


Thanks for the tip.


SorryDog