Question:

Substr command in SQL (ADO)

by Guest8705  |  12 years, 8 month(s) ago

0 LIKES UnLike

Substr command in SQL (ADO)

 Tags: Ado, command, SQL, Substr

   Report
Answer The Question I've Same Question Too

1 ANSWERS

Sort By: Date  |  Rating
  1. amomipais82
    Hi There,
    you can't use substring on a column of type TEXT.  text fields are up to 2GB of data stored as a binary blob.  if you know your data is smaller than that, you can try to convert to varchar first and then use substring.  but if you have a lot of data it would be better to do this in code (VB, Java, C#, etc.).  If you don't have more than several thousand characters in your largest piece of data, it would be better to make the column a varchar.

    Regards,

Sign In or Sign Up now to answser this question!
You're reading: Substr command in SQL (ADO)

Question Stats

Latest activity: 14 years, 7 month(s) ago.
This question has 1 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Register Now