IT Process Automation

 View Only
  • 1.  Obtain userid from mdb with Select from Database Operator

    Posted Sep 26, 2019 04:50 PM
    I need obtain the userid from mdb with "Select from Database" Operator but, i don't remember the sentence if is U or cnt in SQL

    Example:

    select * from ca_contact where supervisor_contact_uuid = U'444E049572144FCF995EE07820CCBE8D'

    Someone have an example please?


  • 2.  RE: Obtain userid from mdb with Select from Database Operator
    Best Answer

    Posted Sep 27, 2019 07:00 AM

    select * from ca_contact where supervisor_contact_uuid = 0x444E049572144FCF995EE07820CCBE8D


  • 3.  RE: Obtain userid from mdb with Select from Database Operator

    Posted Oct 01, 2019 03:55 PM
    Thanks Oliver.