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: Like

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

Hope this helps,
User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Return to DB2


  • Related topics
    Last post