Ask a Question related to Coldfusion Database Access, Design and Development.
-
Merlyn MM #1
numeric part of a string
Can anyone tell me how can I get the numeric part of a string .
for example I'm using this..Select substring('walnut 2224
kill',PATINDEX('%[0-9]%[0-9]%','walnut 2224 kill'),4)
when I know the length of the numeric part is 4 but I want to retrieve
regardless of the length of the numeric part and where its positioned.
Please help me.
Thank you.
Merlyn MM Guest
-
string becomes numeric?
Hi, I am trying to dump a query out into an excel. I found that a varchar datatype column will be converted to numeric in the Excel. For... -
How to sort a String column as Numeric?
I have a datagrid (dgResults) that I am populating from a SQL stored procedure. After I fill my dataset (ds), I cache the dataset this way:... -
Parse part of string (mid string function ?)
Can someone tell me how to parse part of a string? I can use the following: <?php $text = $_SERVER; //$PHP_SELF //(document.url); echo $text;... -
Problem converting array string back to numeric
I'm afraid I don't know enough about your situation to help. How are you sending your values to ASP? It sounds to me like this is more like an ASP... -
Select with numeric conditions in the where part
Try this: http://www.winnetmag.com/Articles/Index.cfm?ArticleID=21365 -- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA Author: ADO.NET and XML:... -
jonwrob #2 Re: numeric part of a string
You don't say what database you're working with, but most have some means of working with regular expressions. Look into regular expressions for your database.
JR
jonwrob Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
