Shall we use variables in LIKE



IBM's flagship relational database management system

Shall we use variables in LIKE

Postby Shakthivel V » Sun Jul 18, 2010 3:38 pm

Hi.. Shall we use variables in LIKE

Example :


move 'mainframe' to variable-name

Select.................... like 'Variable-name%'


Is the above code will work??
Shakthivel V
 
Posts: 22
Joined: Thu Mar 04, 2010 12:12 am
Has thanked: 0 time
Been thanked: 0 time

Re: Shall we use variables in LIKE

 

Re: Like

Postby dick scherrer » Sun Jul 18, 2010 10:31 pm

Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post