<div>
doesn't<br />
<br />
select convert(varchar(255), memofield)<br />
<br />
work?
</div>


doesn't

select convert(varchar(255), memofield)

work?

<div>
I was sorta vague on what I was doing I guess.<br />
<br />
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. &nbsp;Therefore I was trying to cast the field to a varchar.
</div>


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.

<div>
This is exactly what I was thinking. &nbsp;Your first comment got me heading that way, and this second one makes me feel all warm and fuzzy.<br />
<br />
Thanks for your help!<br />
<br />
Brian
</div>


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!

Brian

<div>
<div class="content wysiwyg-content">
I am having trouble finding a command to cast a memo field to a VARCHAR in SQL. &nbsp;I want this as part of the WHERE clause.<br />
<br />
Thanks,<br />
Brian
</div>
</div>


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.

Thanks,
Brian

Casting Memo Field to VARCHAR in mSQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.