Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I need to select records based on a substring value using xml code.

Status
Not open for further replies.
MrBillSC

MrBillSC

Programmer
Aug 6, 2001
592
US
Hi All,

I am using xml code to retrieve records from a database and will display them in a report. I only want to select records where the 5th character in "VP_Permits.TypeCode" = "G". I can't seem to figure this one out. Can anyone help?

Thanks,
mrBill
 
Sort by date Sort by votes
Could you provide a better definition of "xml code" please?

Tom Morrison
Micro Focus
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

smak1
  • Locked
  • Question
add structure to XML
Replies
0
Views
550
smak1
smak1
Bijan Borazjani
  • Locked
  • Question
XML to PDF
Replies
0
Views
643
Bijan Borazjani
Bijan Borazjani
P
  • Locked
  • Question
How to re-use a recursive template
Replies
1
Views
628
pdrapeau
P
198709km
  • Locked
  • Question
Grouping XML key value using XSLT
Replies
1
Views
598
atlopes
atlopes
cdr_greg
  • Locked
  • Question
Display XML Line Breaks in Microsoft Word Content Controls
Replies
0
Views
805
cdr_greg
cdr_greg

Part and Inventory Search

Sponsor

Back
Top