Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Image to Text?

Author  Topic 

pallaire
Starting Member

1 Post

Posted - 2006-03-14 : 17:19:35

Hey Folks,
I'm looking for a good way to convert in SQL Server proper(i.e. w/o an extended stored proc) to convert text data stored in an Image Field, back into Text data. Any ideas? Anyone seen this done? Or failing that know of a third party or has a stored proc that does the conversion?

Thanks,
Paul

bekkabo
Starting Member

1 Post

Posted - 2006-03-30 : 10:37:03
try this...
CONVERT(varchar(8000),CONVERT(binary(8000),[BITS])) as BITS
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-03-31 : 00:47:11
quote:
Originally posted by bekkabo

try this...
CONVERT(varchar(8000),CONVERT(binary(8000),[BITS])) as BITS


Is this for SQL Server 2000?
You may need to do this in Front End application
Refer this also
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part3/c1161.mspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -