User Profile

radhekrsna · Aug 2 '12, 06:50 AM

hmm ... let me specify my goal
I want to perform separate actions on the table when the values in a certain column fall in the following criteria:

when the value is purely alphabetic
when the value is purely numeric and upto 4 digits
when the value is less than 4 digits/characters
when the value is longer than 4 digits/characters

pls guide me on the best approach to achieve this if not via cursors.

ra...

radhekrsna · Aug 1 '12, 04:19 AM

Hi Rabbit!
Thank you so much for your reply!

actually multiple records need to be checked for this condition, so i figured that use of cursor would be required.

is it possible to acheive this without cursor.

also i am cofused how can i differentiate between a purely numeric string from one that is alphanumeric? could you please help?

eg 1234 is fine
but 12ab or ab12 is returned...

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

How to return records where the value in column is less than 4 digits using cursor