Sybase Update VARBINARY TEXT

Hi,

I need your help please.

I'm using Sybase database to complete this task.
I have update BSTX_TEXT field that is VARBINARY TEXT
to say "NON GROUP VBIP"

The field currently encrypted and stored as VARBINARY TEXT
what I want is to change the text field name in it.

Is there a way to read this VARBINARY ?

UPDATE dbo.CMC_BSTX_SUM_TEXT SET
 convert(char(70), BSTX_TEXT) as BSTX_TEXT = 'VBID PRESTIGE OPTION'
WHERE PDBC_PFX = 'E595'

Thanks,
Lulu
lulu50Asked:
Who is Participating?
 
Pawan KumarConnect With a Mentor Database ExpertCommented:
try with giving size..
UPDATE dbo.CMC_BSTX_SUM_TEXT 
SET BSTX_TEXT = CONVERT( varbinary(1000) , 'BCNA NON GROUP VBID PRESTIGE OPTION LEVEL 1 (HIGH) 2018' ) 
WHERE PDBC_PFX = 'E595'
AND BSBS_TYPE = '0001'

Open in new window

0
 
lulu50Author Commented:
can I do this

UPDATE dbo.CMC_BSTX_SUM_TEXT SET convert(char(70), BSTX_TEXT) = VBID PRESTIGE OPTION LEVEL'
FROM dbo.CMC_BSTX_SUM_TEXT
WHERE PDBC_PFX = 'E595'
AND BSBS_TYPE = '0001'
0
 
Pawan KumarDatabase ExpertCommented:
can you explain wht you want to achieve?
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
Pawan KumarDatabase ExpertCommented:
Please try this-

UPDATE dbo.CMC_BSTX_SUM_TEXT 
SET convert(char(70), BSTX_TEXT) = VBID PRESTIGE OPTION LEVEL'
WHERE PDBC_PFX = 'E595'
AND BSBS_TYPE = '0001'

Open in new window

0
 
lulu50Author Commented:
I have to update the text in that field
0
 
Pawan KumarDatabase ExpertCommented:
Please try this -

UPDATE dbo.CMC_BSTX_SUM_TEXT 
SET convert(char(70), BSTX_TEXT) = 'VBID PRESTIGE OPTION LEVEL'
WHERE PDBC_PFX = 'E595'
AND BSBS_TYPE = '0001'

Open in new window

0
 
lulu50Author Commented:
I'm getting this error

Error (102) Incorrect syntax near '='.

when I run this

UPDATE dbo.CMC_BSTX_SUM_TEXT
SET convert(char(70), BSTX_TEXT) = 'BCNA NON GROUP VBID PRESTIGE OPTION LEVEL 1 (HIGH) 2018'
WHERE PDBC_PFX = 'E595'
AND BSBS_TYPE = '0001'
0
 
Pawan KumarDatabase ExpertCommented:
pls Try this-

UPDATE dbo.CMC_BSTX_SUM_TEXT 
SET BSTX_TEXT = CONVERT( varbinary(max) , 'BCNA NON GROUP VBID PRESTIGE OPTION LEVEL 1 (HIGH) 2018' ) 
WHERE PDBC_PFX = 'E595'
AND BSBS_TYPE = '0001'

Open in new window

0
 
lulu50Author Commented:
Error (156) Incorrect syntax near the keyword 'max'.
0
 
lulu50Author Commented:
oh Pawan!!!!!

it worked!!!!

Thank you so much !!!!

Thank you and Thank you one more Thank you
0
 
lulu50Author Commented:
Thank you
0
 
Pawan KumarDatabase ExpertCommented:
welcome.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.