Question:

Substr command in SQL (ADO)

by Guest11398339  |  2 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. Ali Abdullah
    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,

You're reading: Substr command in SQL (ADO)

Question Stats

Latest activity: 2 years, 8 month(s) ago.
This question has been viewed 109 times and has 1 answers.

BECOME A GUIDE

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