pathfinder7377
Technical User
I have a client that uses a SQL database system. They have a field / column that is a blob that contains paragraphs of text. They need to be able to search within those fields for strings of text and return the value of a second field as a result of that search.
Is there a reporting function in SQL that will permit this or do I need to export this to Access or something similar. I have tried the Access method but the data does not convert from the "binary large object" format in the SQL database. Am I missing a step in the conversion or do I need to go to something like Crystal Reports?
I am not an experienced SQL programmer but do a fair amount of database work. Any help will be appreciated.
Is there a reporting function in SQL that will permit this or do I need to export this to Access or something similar. I have tried the Access method but the data does not convert from the "binary large object" format in the SQL database. Am I missing a step in the conversion or do I need to go to something like Crystal Reports?
I am not an experienced SQL programmer but do a fair amount of database work. Any help will be appreciated.