Results 1 to 2 of 2

Thread: Astrex

  1. #1
    Join Date
    Feb 2014
    Posts
    1

    Unanswered: Astrex

    Hi all,

    I'm trying to add a astrex to a quantity to turn it into a code 39 bar code

    I have used this formula before with crystal and it works fine
    "*"+{stquem.users_text_field}+"*"



    But with this one I now get a string required here message?
    "*"+{stqeum.quantity}+"*"


    Can anyone help please?

    Thanks

    Lee
    Last edited by Leeroy1; 02-23-14 at 06:21.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Try:
    Code:
    '*' + CAST(stqeum.quantity AS NVARCHAR(50)) + '*'
    Note: As far as I know, braces ({}) are not part of the T-SQL syntax.
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •