Board index MS SQL Server

Including a text field in a SELECT statement

Including a text field in a SELECT statement

Post by Nate Heldma » Tue, 26 Jan 1999 04:00:00



I have a query that return about 10 fields of data which is run on an ASP
page, and returned as HTML.  I am able to write all of the data until the
APS tries to write the the text field.  There is a WHERE clause in the
statement, and I have found a bit of info stating that the text field will
not work with a WHERE statement unless there is also a LIKE statement.  My
problem with that is that I don't know what is contained in that statement
so I cannot compare it with anything.  I am VERY new to SQL, and am learning
it on the fly.  Any help would be greatly appreciated.  The statement in its
entirety is below.

"SELECT * from crtrklst WHERE cr_ctrl_num = '" & controlnum & "';"

The text field that I am trying to retrieve and display is "issue_desc" and
is part of the table crtrklst.

Thanks in advance for your help,

Nate

 
 
 
Top

1. How to include Column/Field Size to SELECT...Statement

How can I include column/field size to the following:

select TABLE_NAME, COLUMN_NAME, DATA_TYPE
from information_schema.columns

SAM.

2. Print Preview Page Fault

3. USING A FIELD FROM MAIN SELECT STATEMENT IN SUB SELECT STATEMENT

4. sp_MSmakegeneration.sql

5. text field to HTML with text style included?

6. Setting table var problem

7. Remove Commas from text field in Select statement

8. NextRecordset method performance

9. Select statement performance question - DDL included

10. How to include parameter into select statement ?

11. Include value from stored procedure in SELECT statement

12. Include custom function in SELECT statement?

13. Including Line number in a select statement


All times are UTC
Board index