hi, can you help to convert the following sybase procedure to oracle function?
create proc valid_chartime @chartime varchar(8), @fmt int as
declare @hh int
declare @mm int
declare @ss int
de...
http://www.experts-exchange.com/Database/Oracle/Q_20187363.html
Zones:
OracleDate Answered: 04/29/2002 Grade: A Views: 0
SELECT substring(dbo.UserQuizzes.UserID, patindex('%[^0-9]%', dbo.UserQuizzes.UserID),
The above code works ok if all records in the search
find the characters being 'patindex'ed, but on...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20305790.html
Hi,
I have a SQL statement "Create View" in MS SQL Server as below, now I want to create Queries in MS Access that have results as the same "Create View" statement. I'm beginner MS Access, it's di...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20827789.html
Zones:
MS AccessDate Answered: 12/24/2003 Grade: B Views: 0
Hi,
Please see this query:
select track_id,track_name from track_master where patindex('%'+rtrim(ltrim(str(track_id)))+'%', '36,37') <> 0
This query returns me the following results
trac...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21147598.html
Zones:
DatabasesDate Answered: 09/28/2004 Grade: A Views: 0
Dear Experts,
I have the following string: CO_DD_MM_YY_HI
Fields CO, DD, MM, YY, HI represent numbers with leading 0's removed..
e.g. 1_12_93_2_8 ,
33_4_45_35_2
What I need to do, i...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21220323.html
I currently have 2 UDFs I created to break a name from the following format into each part:
Kendall Jr, Joe D
It works fine except for instances where the Middle Name is present not just a Mi...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21898132.html
here's my msgID value: AAAA061206003028314^74842238^QQQQ
the format of the msgID string is this:
AAAA - endpoint
061206 - DDMMYY
003028314^74842238^QQQQ - ordernumber
i'm using this...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21901087.html
I need to retrieve the date from a varchar/memo field, it could be formatted either mm/dd/yy or mm/dd/yyyy. Id like to use PATINDEX as part of a function but unable to get the pattern correct fo...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22136690.html
I don't understand what the > 10 is doing.
SET @Location = PATINDEX('%ProductID=%',@ProductDescription)+10 -- Sets starting position to the start of the ProductID number after the = sign
WHIL...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22155199.html
-- I need to correct the "domain" substring of my email field. So the following query:
SELECT mailname=SUBSTR(email,1,PATINDEX('%@%',email)-1 ),
at=SUBSTR(email,PATINDEX('%@%',email),...
http://www.experts-exchange.com/Database/Sybase/Q_10976101.html
Zones:
SybaseDate Answered: 08/13/2000 Grade: B Views: 0
