Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to use concat in parameter

  1. #1
    Join Date
    Feb 2017
    Posts
    2

    Question How to use concat in parameter

    Hi all ,

    I need help to get middel word in column i use this syntax but it's not working with pentaho

    SELECT * FROM <table_name>
    WHERE <column_name> LIKE CONCAT('%',${name_parameter} , '%')

    Any one can help me in this issue ??

    regards,

  2. #2
    Join Date
    Aug 2016
    Posts
    142

    Default

    It works fine for me

    Is your parameter type set to String?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.