How can i search Nvarchar value in sql ...?

Question

1.00/5 (1 vote)

See more:

Hi I am searching lattitude,longtude values in where condition i.e

Latitude LIKE '%'+@latitude+'%' and Longitude LIKE '%'+@Longitude+'%'
but lattitude,longtude datatypes is nvarchar so getting some problems in searching the data type is navrchar but I entered float values ....?
what is the alternate datatype instead of 'like'

Posted 18-Nov-13 3:39am

Gujula Ravindra Reddy

Updated 18-Nov-13 4:57am

CHill60

v2

Add a Solution

Comments

Mike Meinz 18-Nov-13 9:43am

There are several different formats used to specify latitude and longitude. If you are using Signed Degrees format (a signed numeric value), you can store in the database as a decimal number and compare it using >=, <- or = in a SQL Select statement Where clause. I wouldn't use the Like operator to compare latitude and longitude values.

See Latitude and longitude formats.

If you are using one of the Degrees-minutes-seconds formats to store latitude and longitude, the problem becomes a bit more difficult. Without knowing the format of you latitude and longitude values, it is difficult to provide help. I would urge you to use Signed Degrees format instead.

ZurdoDev 18-Nov-13 10:02am

Why is it a problem? Perhaps show some sample data and explain why it's an issue.

RedDk 18-Nov-13 12:54pm

I'll bet this question is about geospatial data types. In which case BOL(icrosoftm) is the place to gain insight.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bernhard Hiller · Answer 1 · 2013-11-18T21:50:00

Solution 1

Get rid of the nonsense of storing numerical values formatted as characters! Use an appropriate numerical type (signed, with some decimal places).
Then your comparison could be e.g.

SQL

WHERE (Latitude BETWEEN 12 AND 13) AND (Longitude BETWEEN 78 AND 79)

Posted 18-Nov-13 21:50pm

Bernhard Hiller