DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2001

    Can any one please let me know how to Find apostrophe ' in a parameter that the user is specifying to execute a procedure
    I want to check within the Procedure if the User Specifies any character like ' " / within the IN Parameter then I will do some processing. The Position of the character is not evident and even not required.

    Please let me know... Thanks in advance.

  2. #2
    Join Date
    Nov 2000
    if instr(input_parameter, '''') > 0 then
    there is a single quote somewhere in input_parameter.

    to look for a space, use
    instr(input_parameter, ' ')

    to look for a slash, use
    instr(input_parameter, '/')


Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.