Binary data

• Pedro Reis-267786

  Mr or Mrs. 500

  Points: 590

  More actions

  October 2, 2006 at 10:51 am

  #97734

  Hi!

  Some fields in my database are Binary data type,

  I want to to do something like if binary_data_field = '122-2123-..' then binary_data_field2 = 'TOM'

  (...its an example)

  How can i achieve that ?

  My querie is the following

  SELECT     authorid, dbo.KNB_Items.HelpTopicID, dbo.KNB_ItemCultures.TopicName AS Titulo,

  published,

  -- (if authorid='9D0E292E-B906-47BE-B62E-5D984F2F52ED' then --- 'JOLIVEIRA') as Autor

  FROM         dbo.KNB_Items INNER JOIN

                        dbo.KNB_ItemCultures ON dbo.KNB_Items.ID = dbo.KNB_ItemCultures.ItemID

  where dbo.KNB_items.helptopicID >'25000' and dbo.KNB_items.helptopicID <'50000'

  and date > '2006-09-01'

  order by dbo.KNB_Items.HelpTopicID

• Farrell Keough

  SSCoach

  Points: 17414

  More actions

  October 2, 2006 at 3:11 pm

  #663730

  Look up CASE in BOL...

  I wasn't born stupid - I had to study.