Member Avatar for ssudhamca

hello i want two table records in substring query

table1 name (membermaster )
column names
mficode,centercode,membername
values
ex
045323,1061,shanthi

table2 name (memberloanmaster)

column names
loanrefcode ,centercode,closedate
values
ex
045323/1,1061,2009-04-03,

both tables mficode and loanrefcode and centercode as comman, how do i select mficode and
centercode and membername, compare with loanrefcode for second table.


the diff for mficode and the loanrefcode is only in after the value only '/'

exa: mficode for 1 st table
045323

exa: loanrefcode for 2nd table
045323/1

  • 3 Contributors
  • 2 Replies
  • 72 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by ithelp
sknake commented: duplicate urgent posts -2
Member Avatar for Thirusha

If the length is always the same amount than u can use the substring function, there are two of them:
SUBSTRING(str,pos)
SUBSTRING(str,pos,len)

Member Avatar for ithelp

And what got you struck ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.