Casting Memo Field to VARCHAR in mSQL

I am having trouble finding a command to cast a memo field to a VARCHAR in SQL.  I want this as part of the WHERE clause.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.


select convert(varchar(255), memofield)

BrianGAuthor Commented:
I was sorta vague on what I was doing I guess.

I am trying to run a Seagate Crystal report and I need to get records where a memo field is equal to a certain thing, however Crystal reports does not like to have a memo field in the query.  Therefore I was trying to cast the field to a varchar.
Are you talking about

select blah blah
from mytable, yourtable
where convert(varchar(255), mytable.memofield) = yourtable.col

--- or ---

If Crystal is using a visual query wizard, I get around that by creating a view and using the view rather than the table in Crystal  (eg)

create view trickCrystal
select col1, col2, col3, convert(varchar(255), memofield) col4
from mytable

Then use trickCrystal instead of myTable as your source for Crystal reports (trickCrystal may not be the most appropriate name for your view)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BrianGAuthor Commented:
This is exactly what I was thinking.  Your first comment got me heading that way, and this second one makes me feel all warm and fuzzy.

Thanks for your help!

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.