SQL Query / Text Fields

Results 1 to 2 of 2

Thread: SQL Query / Text Fields

  1. #1
    Join Date
    Dec 1969

    Default SQL Query / Text Fields

    When using ASP to query a SQL table with a text field, I would like to format specific text strings in the the result. <BR>example <BR>query returns: now is the time for all good men..... <BR><BR>I would like to format "is the time" as "&#060;b&#062;is the time&#060;/b&#062;" <BR>

  2. #2
    tvrepair Guest

    Default RE: SQL Query / Text Fields

    Have you tried the Replace function? <BR>Like:<BR><BR>strQueryReturn = &#039;however you get your query return<BR>strSub = "is the time"<BR><BR>If InStr(strQueryReturn, strSubString) &#062; 0 Then<BR> strResult = Replace(strQueryReturn, strSub,"&#060;b&#062;" & strSub & "&#060;/b&#062;") <BR>End If

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts