InStr Function Questions and Answers

Recent IT Questions

1 - 3 of 3
<<PREVIOUS 1 NEXT>>

UE SUBSTR or RTRIM?

I need to get cities' name from a format like this: Los Angeles, CA New Orleans, LA etc.. I've tried: substr(a.air_location, -4) but that gives me the opposite...", LA" Any suggestions? Thanks.

View Answer   |  May 7 2009  5:21 AM GMT
SUBSTR, RTRIM, InStr function
asked by Antgaudi

  5 pts.

double quotes with InStr method

how to identify a string with double quotes using the InStr method in vb

View Answer   |  Mar 5 2009  6:11 PM GMT
InStr function
asked by Jwohlbe

  5 pts.

INSTR ()

Hi Experts, My test case s working fine for the INSTR() but the same if i use in implemenation its not raising the error giving below the pseudo code IF INSTR (v_lm,pcd,1,1) = 1 OR INSTR(vlm,pc,1,1) = 1 OR INSTR(vlm,pcn,1,1) = 1 THEN raise_application_error(...

View Answer   |  Jan 12 2009  12:02 AM GMT
PL/SQL block, InStr function, PL/SQL
asked by Inprise

  525 pts.

1 - 3 of 3
<<PREVIOUS 1 NEXT>>