Oracle Select SQL

Results 1 to 2 of 2

Thread: Oracle Select SQL

  1. #1
    Join Date
    Dec 1969

    Default Oracle Select SQL

    In Oracle, I have a table that has a column (AccountNumber) that contains a mix of alpha and numeric text (example: 123WOH456).<BR><BR>I need to select rows from the table where the last two characters of AccountNumber are &#039;56&#039;. It has to be something like this:<BR><BR>Select * From Table<BR>Where Right(AccountNumber, 2) = &#039;56&#039;<BR><BR>But I don&#039;t know how to convert this sort of SQL statement to Oracle syntax. Can someone help?<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default SUBSTR() function. (eop)


Posting Permissions

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