473,473 Members | 1,847 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

How to the numbers which start by a number given in a database?

1 New Member
Example:
1235
23985
23444

number given is 23
results:2
Dec 9 '10 #1
1 1358
johny10151981
1,059 Top Contributor
if the field is number then

the query should be

Expand|Select|Wrap|Line Numbers
  1. SELECT COUNT(*) from desired_table where (desired_field/100)=constant_number
  2.  
this query is only for first 2 bytes

if it is string
Expand|Select|Wrap|Line Numbers
  1. SELECT COUNT(*) from desired_table where desired_field like '%constant_number'
  2.  
Dec 9 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Colin Steadman | last post by:
I have an ASP site that allows the user to submit an Employee Number to an Oracle procedure. The procedure does some calculations and the results are displayed in the browser. Now, the user...
5
by: Felix Collins | last post by:
Hi All, does anyone know any cleaver tricks to sort a list of outline numbers. An outline number is a number of the form... 1.2.3 they should be sorted in the following way... 1 1.1 1.2
6
by: malv | last post by:
Simple case: In this list, how to find all occurences of intervals of n adjacent indexes having at least one list-member with a value between given limits. Visualizing the list as a...
0
by: prateekbaxi | last post by:
Hi, Iam trying to write a small FTP client which accepts the IPAddress and connects to this FTP server. Now when I use DNS.GetHosbyAddress it failes and reutrns the Socket Exception "The...
2
by: Terry Olsen | last post by:
I have an array filled with counts of numbers. Example: ar(1) contains the number of occurrances of the number 1 ar(2) contains the number of occurrances of the number 2 etc... I need to find...
4
by: Erwin Leonardi | last post by:
Hi there, Suppose computer PC1 is my database server in which DB2 is running. I have an application running in computer PC2. The application PC2 will connect to DB2 in PC2. How can my...
16
by: some old html fumbler | last post by:
I want to use CSS to get an ordered list to start with something other than a 1 or equivalent. I have a list of things that happen during the course of a year. Too long a list is not helpful, so...
16
by: skip | last post by:
The thread on sorting in Python 3 got me to thinking. How could I sort a list of complex numbers using key? As expected: Traceback (most recent call last): File "<stdin>", line 1, in...
1
by: Lura | last post by:
In an effort to learn how to work with information in files, I am writing a program that opens an already existing file containing decimal numbers. It then takes the decimals, sorts them, and returns...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.