gardan06 Posted April 30, 2008 Share Posted April 30, 2008 i have 2 tables joined wherein a.seq_no (w/c value is either 1, 2 or 3) should exist in b.number_choice(w/c value is either 1*, 1*2* or 1*2*3*). is using the like function to a variable possible? Quote Link to comment Share on other sites More sharing options...
gardan06 Posted April 30, 2008 Author Share Posted April 30, 2008 never mind, i got it myself.. seems like concat can be exploited to create your own like comparison Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.