473,387 Members | 1,573 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Checking valid value format

255 100+
In regarding to the solution from this question through SQL query. The result I obtained contains values in other formats I don't want.

The format of the values is length between 3 and 4 characters. The first and last character of the value are alphabets, and the middle ones is/are numerics. E.g. A1A, A12A

In the result I'm getting in the previous solution, there are also some other values such as BACK0, LOAD3, etc.

How can I filter out unwanted results in the query? Many thanks with all suggestions.
Dec 7 '10 #1
2 1942
colintis
255 100+
I think I have eliminate the problem.

Simply add additional line in the query
Expand|Select|Wrap|Line Numbers
  1. IsNumeric(Mid(Locn,2,1))
As the standard formatting, the 2nd character must be a number after an alphabet character. Therefore it can be solve simply checking if that part of the value is numeric.
Dec 7 '10 #2
NeoPa
32,556 Expert Mod 16PB
You have more than eliminated the problem. You've solved it - with a good solution.
Dec 7 '10 #3

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

Similar topics

4
by: Emre Guldogan | last post by:
Hello, In C#, We can read data fields from DB with <%# DataBinder.Eval(Container.DateItem,"field_name") %> but, How can I check a value from DB with a <%# .. %> segment such as <%# If(...
1
by: Julius Fenata | last post by:
Dear all, I need help to change my item-template value format... Here is my case, I have a datagrid, with 'SubjectPrice' field, and when the grid displayed, my 'SubjectPrice' field displayed...
6
by: Alan Silver | last post by:
Hello, I am data binding a repeater that has a checkbox in the ItemTemplate. The data value coming out of the database is a char(1) field containing either "y" or "n". I want to use this value...
0
by: JSantora | last post by:
Essentially, InsertAT is broken! For the past couple of hours, I've been getting this "Parameter name: '-2147483550' is not a valid value for 'index'." error. Apparently, its caused by having...
1
by: Robin Tucker | last post by:
I have a customer (our first "beta" case as it happens) who has Norwegian Windows XP. Our software is not translated to Norwegian (yet), we just have the basic, default, EN version. Anyway, when...
1
by: Bill Nguyen | last post by:
I tried to debug this error message but can't locate it anywhere in my VB forms. Specified argument was out of the range of valid values. '0' is not a valid value for...
5
by: Rob Dob | last post by:
I am trying to set the NullValue within the Column properties of my Dataset in VS2005. The DataType is a System.DateTime. and when I try and change it from "(Throw Exception)" I get the following...
0
by: Tommaso Caldarola | last post by:
I got the following exception System.Runtime.Serialization.SerializationException: The input stream is not a valid binary format. The starting contents (in bytes) are:...
1
by: sandeepbhutani304 | last post by:
have 2 projects communicating each other with .NET remoting. But when I am trying to call these functions I am getting the error: The input stream is not a valid binary format. The starting...
1
oranoos3000
by: oranoos3000 | last post by:
hi would you please help me? i read a refrence for html that was explained about position properties and said that valid value is statc,fixed,absolut,relative but unfortunately i dont...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.