SQL Select Statement Limitation With Access

[smelvincom0]

Is there a limitation with an SQL Select statement going against an Access database. Here is what I tried in my code:

strSQL = "SELECT '<DL><DT class=question>'+Question+'</DT><DD>'+Answer+'</DD></DL>' FROM FAQ"

but when I use this statement I notice it chops the data around 255 characters.

Does anyone know this is an actual limit? I know there is a couple of ways around this but does anyone know of a simple way of telling the SQL Select statement to bring back more than the limit?

Mike
***

[bruce]

is your data type set to only have 255 characters for that column?

[b]quote:Originally posted by smelvincom0

Is there a limitation with an SQL Select statement going against an Access database. Here is what I tried in my code:

strSQL = "SELECT '<DL><DT class=question>'+Question+'</DT><DD>'+Answer+'</DD></DL>' FROM FAQ"

but when I use this statement I notice it chops the data around 255 characters.

Does anyone know this is an actual limit? I know there is a couple of ways around this but does anyone know of a simple way of telling the SQL Select statement to bring back more than the limit?

Mike
***

</blockquote id="quote"></font id="quote">

B.

DiscountASP.NET
http://www.DiscountASP.NET

[smelvincom0]

The Question column is. The Answer column is a Memo.

I may be getting ahead of myself but it sounds like since I used a 255 text column in my statement the result is the combination of those 2 columns and truncating it to the smallest column size. In my case 255 text. Is that true?

I got around the problem by simplying creating a datalist with 1 column and it worked nicely.